Record sorting

[John Smith]

Hi
I have a list in one col. of name (new line) address(new line) phone number
(new line) blank line

John Smith
15 Green St
555 8560

Bill Brown
etc.

Question
Can I sort these four line records into four cols. so all the names and
addresses and phone numbers are in individual cols?

Many thanks
Stephen West
Gold Coast, Australia

 

[JE McGimpsey]

One way:

Put this into a second sheet. Assume that the names in Sheet1 start in
cell A1:

A1: =INDEX(Sheet1!$A:$A,(ROW()-1)*4+COLUMN())

Copy it across to C1, then copy A1:C1 down as far as required.

You can then select columns A:C, Copy them, and choose Edit/Paste
Special, selecting the Values radio button to convert the formulae into
constants.

 

[John Smith]

Many thanks it works exactly the way I Wanted!

One way:

Put this into a second sheet. Assume that the names in Sheet1 start in
cell A1:

A1: =INDEX(Sheet1!$A:$A,(ROW()-1)*4+COLUMN())

Copy it across to C1, then copy A1:C1 down as far as required.

You can then select columns A:C, Copy them, and choose Edit/Paste
Special, selecting the Values radio button to convert the formulae into
constants.