W
Windy
How can I take data that is in three columns, 180 rows and make it 6 columns,
90 rows?
90 rows?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
dlw
cut and paste
F
F.G.
How can I take data that is in three columns, 180 rows and make it 6 columns,
90 rows?
can you be more pscific on what do you want to do.
if one column cotains Firstname, Lastname for example you can put it
in two columns by selectin Data>Text to columns and chose coma as
seperator.
FG
P
Pete_UK
You might want to take the data which is currently on rows 1 and 2 and
put them side-by-side, and then rows 3 and 4, 5 with 6 etc, or take
row 1 and row 91 and put those side-by-side, then 2 with 92, 3 with 93
etc.
Any preferences?
Pete
put them side-by-side, and then rows 3 and 4, 5 with 6 etc, or take
row 1 and row 91 and put those side-by-side, then 2 with 92, 3 with 93
etc.
Any preferences?
Pete
P
Pete_UK
David McRitchie has some notes on how to produce newspaper-type
columns here:
http://www.mvps.org/dmcritchie/excel/snakecol.htm
Hope this helps.
Pete
columns here:
http://www.mvps.org/dmcritchie/excel/snakecol.htm
Hope this helps.
Pete