organizing from vertically to horizontally in rows

[Kurt14]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

Ok I am trying to organize a list that looks like -

Last name, first name
address
county
city
phone
fax
business

Last name, first name
address
county
city
phone
fax
business

To where is looks organized under rows where is appears like -

Last name | First name | address | county | city | phone | fax | business
Last name | First name | address | county | city | phone | fax | business

without having to cover the 5000+ list manually organizing.

 

[Laroche J]

Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel

Ok I am trying to organize a list that looks like -

Last name, first name
address
county
city
phone
fax
business

Last name, first name
address
county
city
phone
fax
business

To where is looks organized under rows where is appears like -

Last name | First name | address | county | city | phone | fax | business
Last name | First name | address | county | city | phone | fax | business

without having to cover the 5000+ list manually organizing.

To make it workable the lines with the Last name MUST repeat at regular
interval, for example every 8th line. Let's assume all your data is in
column A, starting at line 1.

In cell D1 of the same sheet, enter this formula (do a cut and paste to make
sure nothing is lost):
=INDIRECT(ADDRESS(8*(CELL("row",D1)-1)+CELL("col",D1)-CELL("col",$D$1)+1,1))

Adjustments if necessary:
8 is the interval of lines between each original record.
The second last 1 is the line number of the first record of original data.
The last 1 is the column number of the original data. 1 is for column A.
You can use another column than D to start, update all three references if
you do so.

After making sure cell D1 now shows the first Last name, copy the content of
D1 in E1:K1. Then select cells D1 to K1, and copy down until line 5000+, as
you expect the number of records to be. Since dragging the corner dot will
be very tedious over 5000 lines, proceed like this: after selecting D1:K1
and pressing Control-C to copy, go to the Edit menu and choose Go To. Type
K5100 in the address box and click OK. Then press Command-Shift-CursorUp,
which will bring you to K1, then press Shift-CursorLeft until you reach D1.
Finally press Control-V to paste in the whole highlighted area. Make sure
you have enough lines of formulas, add more if needed.

When everything is reorganized, save your file under a new name (we're never
too prudent), select the reorganized records, copy, and paste special as
values. Finally delete columns A:C. Save again.

JL
Mac OS X 10.4.11
Office v.X 10.1.9, Office 2008 trial

 

[Kurt14]

Dang, some have info added or missing... so is doesn't end on a same line every time..