Positioning data in single column for a graph.

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

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