changing columns

[Windy]

How can I take data that is in three columns, 180 rows and make it 6 columns,
90 rows?

 

[dlw]

cut and paste

 

[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

 

[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

 

[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