Formatting data into 1 column into 3 columns???

  • Thread starter Thread starter Tricia
  • Start date Start date
T

Tricia

Hello,
I have a spreadsheet that has text in 1 column (64 pages)
and I need to format so that it ends up in three columns.

For example the column looks like this
name
address
phone
name
address
phone
etc.

I need it to go across like:
name address phone

Is there a way to make this happen???

MANY THANKS if anyone can help!!!
Tricia
 
Make sure you have a back up first.!

Assuming the first name of your list is in a1
Enter in b1 ....=a1
in c1......=a2
in d1.....=a3
extend down the column as far as you need to.
enter in e1 ....1
in e2......2
in e3......3
extend this column so that you repeat the series 123123123etc
you may have to hold <cntr> button while you extend

select columns b c and d
copy paste special values
to change the formula's into data

select the whole area covering columns bcd and e
go to data sort
sort by column e

all the lines with 1 in e column should now show
as one group

Regards
Bill K
 
If the functions in the downloadable file at
http://home.pacbell.net/beban are available to your workbook, and
assuming your data is in a range named "datarange"

=ArrayReshape(datarange,ROWS(datarange)/3,3) array entered into a
3-column range of rows equal to 1/3 the number of rows in datarange. If
you select too many rows, #N/A! will appear in the extras.

Alan Beban
 
Back
Top