Transposing Excel Data from a Vertical Format to a Horizontal Format

[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

 

[Ken Wright]

Is every record 7 rows in length?

If so, then assuming your data is in Sheet1 starting in A1 with the first
element of the first record, in Sheet2 in cell A1 put the following formula and
then copy it to A1:Gxx, with xx being 1/7th of your rows total on Sheet1, eg if
you have 700 rows of data on sheet 1 you will copy to A1:G100.

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