Moving Rows to Columns

[Paul]

I have a text file that I am importing that has
information on multiple rows (each entry has three rows of
data). I would move each row of data into a column. Anyone
have any ideas/macros on how to do this?

 

[Paul Falla]

Dear Paul

Select the row of data, Copy it, move to the cell of your
choice (I would recommend on a new worksheet).Edit/Paste
Special/Tick the transpose box.

Hope this helps

Paul Falla