Transposing Vertical Data to Horizontal Data On Excel

[cdmjmk]

Hello, I would immensely appreciate it if somebody could help me wit
this urgent problem I have.

A person who drafted a previous document put company info in a vertica
manner instead of a horizontal matter. For instance, this worker pu
data for two companies, Newco Pictures and Sysco Foods, like this:

Newco Inc.
John Travers
22 West Elm Street
Huntington Beach, CA 92660
Phone: (949) 290-3920
Fax: (949) 231-2093
Email: (e-mail address removed)
Sysco Foods
Jane Smith
5432 Westbard Ave.
Costa Mesa, CA 92625
Phone: (949) 990-2039
Fax: (949) 420-2093
Email: (e-mail address removed)

I would like to efficiently convert my data to look like this:

Name Employee Address (etc)

Newco Inc. John Travers 22 West Elm Street (etc)

Sysco Foods Jane Smith 5432 Westbard Ave.


Can Anybody tell me how to efficiently do this, I would be reall
grateful. Thanks a lot

 

[theillknight]

Does this help:

Copy your data.

Edit - Paste Special - Tranpose

 

[theillknight]

Try:

Copy your data.

Edit - Paste Special - Transpose.

Does that work

 

[cdmjmk]

sorry, that doesn't help me as much as I want. I need to be able t
transpose a few hundred lines at a time and have excel have a blank ro
between them. Thanks for the reply though; would you have any othe
suggestions?

 

[DDM]

cdmjmk, I think I can get you part way there. I can't get you the blank
rows, but if you have seven rows of data like this:

Newco Inc.
John Travers
22 West Elm Street
Huntington Beach, CA 92660
Phone: (949) 290-3920
Fax: (949) 231-2093
Email: (e-mail address removed)

and it's always seven rows, I can get it into one row (7 columns) for you.
If the data starts in Sheet1!A1, put this formula in A1 on another
worksheet:

=OFFSET(OFFSET(Sheet1!$A$1,(ROW()-1)*7,0),COLUMN()-1,0)

Copy it to the next six columns and down as many rows as you have companies.