Positioning data in single column for a graph.

Javieros

New member
Joined
May 23, 2014
Messages
1
Reaction score
0
Points
0
Hello,
I am getting data from a wireless tag in the next format
Reading1, Reading2, Readin3
Reading4, Reading5, Reading6
etc.

So I have threee columns and several hundred rows. Could you please tell me if there is a way to organise them in order into a single column?

Thank you,

Javier
 

vinod

New member
Joined
Jun 2, 2011
Messages
15
Reaction score
0
Points
0
Hi Javier,

There are multiple way you can do this, with function or vba Code. let me try to make your life easy with function itself.

1. Copy (Ctlr+C) all the data (3 columns and all the rows) and go to different sheet / cell and paste it as transpose (paste special - Transpose)
2. Cut the second column and paste it below first column and do the same for 3rd column.

Hope I am not confused with my solution : -)

Let me know if you can make it or not..

Cheers!
Vinod
 
Top