column conversion

  • Thread starter Thread starter martin finucane
  • Start date Start date
M

martin finucane

how do i change an excel file that has data in columns that
shd run across the spreadsheet?

in other words, I have data like this

jones 1,000
jones 2,000
jones 99,000

when i would like it to be

jones 1,000 2,000 99,000

i think an earlier post addressed this somewhat but i
didn't understand the variables in the formula...

thks for any help.
 
From a quick search [20 seconds]of Excel Help:

Switch rows of cells to columns or columns to rows

Data from the top row of the copy area appears in the left
column of the paste area, and data from the left column
appears in the top row.

1 Select the cells that you want to switch.
2 Click Copy .
3 Select the upper-left cell of the paste area.

The paste area must be outside the copy area.

4 On the Edit menu, click Paste Special.

Show me

5 Select the Transpose check box.
 
Back
Top