Copy data from Row 1 to Row 5, and then Paste Paste Special Transpose.

You would do this for each company and then delete empty rows.

If all of them are fixed range, say each Company has 5 rows, then you would
use some VBA to save you some time.

--
HTP
Adnan

If I have helped and/or answered your question, please let me know by
replying or clicking question answered (below positioned €˜Yes button).


"PhooPhan" wrote:

I have a worksheet with over 2000 rows of information but it's all
symmetrical. Meaning, Row 1 is a Company Name. Row 2 is the Street Address.
Row 3 is the City, State, Zip. Row 4 is the Phone Number. Row 5 is the Fax
Number. Then Row 6 starts the next Company Information in the same order. I
want to sort this information into Columns so that Column 1 is Company Name,
Column 2 is Street Address, etc.

Does anyone know how this can be done? Thank you.