rows to columns

  • Thread starter Thread starter Waldo710
  • Start date Start date
W

Waldo710

I have a customer list that SHOULD read:

name address phone
name address phone

but it currently reads:

name
address
phone

name
address
phone

Help please?
 
If your data is in Col A from A1
then enter this in B1
=INDIRECT("A"&(ROW()-1)*4+COLUMN()-1)
and copy to D1 and then copy down till end of your data set
Once you get what you want you can copy and paste speical|value
 
Hi,

1. Depending on how many there are you could use the Copy; Edit, Paste
Special, Transpose command.
2. You could use VBA
3. Or, assuming that you data starts in A1 you can enter the following
formula and copy it to the right three columns and down as far as necessary:
=OFFSET($A$1,(COLUMN(A1)-1)+(ROW(A1)-1)*4,0)
 
The easiest way I can think of (without using programming) would be to do
something like the following:

A B C
D
1 name1 =A1 =A2 =A3
2 address1
3 phone1
4
5 name2
6 etc.

Copy B1 - D1 and paste in B5, B9, etc. You can get creative to find the
easiest way to do this.
Copy B1 - D?, select B1, edit | paste special | values
Sort columns B thru D on column B to eliminate blank lines
Delete column A if desired
 
Back
Top