Thread: [Solved] Changing rows into columns
View Single Post
 
Old 12-16-2013, 03:19 PM
paapachak paapachak is offline Windows 8 Office 2010 64bit
Novice
 
Join Date: Dec 2013
Posts: 2
paapachak is on a distinguished road
Default Changing rows into columns

Hi,

I have a huge data of below format:

1 2 3 4 5
6 7 8 9 1
8 5 6 9 7
2 3 6 5 9

I need to read the data in following format
1
2
3
4
5
6
7
8
9
1
8
5
6
9
7
2
3
6
5
9

Could anyone please help me, how to change from above format to below format??

Thanks in advance
Reply With Quote