Hi all,
My first question in this forum. Wish for a great response.
I have a table of data. say like
A B C D E F G H I J
1 2 1 4 5 1 2
1 2 3 4 4 3 3
2 1 3 5 7 4 5
4 5 7 8 9 6 2
I want each row to be converted into a comma delimited cell value. For eg. it should turn the first row as 1,2,1,4,5,1,2 AND PUT THIS VALUE in the I column ( leaving out the K column or any cell that i want to ).
so the next row should be converted to 1,2,3,4,4,3,3 and placed next to the cell where the previous row data was placed.
so after the operation the table should be like this
A B C D E F G H ===== I =============J
1 2 1 4 5 1 2 ======= 1,2,1,4,5,1,2 ====1,2,3,4,4,3,3
1 2 3 4 4 3 3
2 1 3 5 7 4 5
4 5 7 8 9 6 2
and so on for all 5 rows.
Also is there any method by which i can just convert the table into a single value moving from row to column and comma delimited. i.e. 1,2,1,4,5,1,21,2,3,4,4,3,3, and so on.
Thanks all for any help on this !
Bookmarks