transpose or indirect question
 

Is there a formula/method of converting data in column A to columns B
onwards.

I have varying data like:
in cell A1 ABC Company
in cell A2 123 Street Suburb Zip (area code) number

in cell A3 XYZ Company
in cell A4 456 Street Suburb Zip (area code) number

I also have in varying ways an extra address line or phone number or fax or
email. Is there a way of fixing this? eg: for company XYZ i could have in
cell A5 a fax number and in A6 an email address and perhaps and extra phone
number in A7.

I would like it to be:
A1 ABC Company
B1 123 Street
C1 Suburb
D1 Zip
E1 Phone Number.

A2 ABC Company
B2 123 Street
C2 Suburb
D2 Zip
E2 Phone Number
F2 Fax Number
G2 Email Address and so on.

In the past I have used =INDIRECT("A"&3*(ROW(A1)-1)+COLUMN(A1))
This was given to me ages ago by someone in the ng. I am not conversant with
these formulas but I am assuming the first command tells excel that it is a
group of 3 rows (so start again from 4th row)

To make it easier I can manually edit Column A to contain only 3 Cells per
record (prefer not to) Btw each record has no empty cells in between (as
above in A1 to A7 examples)

Any help to resolve this would be appreciated. Pls reply to NG only.
Thanks in advance.