I have a large set of data that I want to convert from one column to multiple column but every new colum should start from the second cell in the previous colum any help please ?
Data
2003
633
8041
334
2655
8182
7896
Desired Result
2003 | 633 | 8041
633 | 8041 | 334
8041 | 334 | 2655
334 | 2655 | 8182
2655 | 8182 | 7896
Last edited by some12; 01-08-2011 at 03:07 AM.
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thank you , but there is one more thing , I want the disired target to be 5 rows only
e.g
DATA
9276
6132
5886
1134
2712
3575
2073
6681
Disired Result
9276 | 6132 |5886 |1134
6132 | 5886 |1134 |2712
5886 | 1134 |2712 |3575
1134 | 2712 |3575 |2073
2712 | 3575 |2073 |6681
and to continue as long as the column is .
Thank you again for your kind reply
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks