Hi All,
I have a datatable which contains the following data;
Col 1 Col2 Col 3 Col 4 Col 5 Col 6 Col 7
A B C D 1,2,3 E F
What I would like to do is make a replica of row 2 (since row 1 is always the column headings) for each item in column 5 which is separated by commas.
So the output would look like;
Col 1 Col2 Col 3 Col 4 Col 5 Col 6 Col 7
A B &nbs ...
Go to the complete details ...