One of my work collegues created a spreadsheet for us to input records. she
set the days up in the collumns and now we have run out of collumns is there
any way of easily transposing the information to rows without having to type
it all in again (we work with Excel 2000)
--
Thank you for reading my post. Hopefully you can answer my querie

Shazza,

Select all your data and click Copy
Select the top left cell where you want to past it but note this mustn't
overlap the copied data so it may be best to paste it to another sheet.

Click paste special and check the transpose box and your done.

Mike

"Shazza" wrote:

One of my work collegues created a spreadsheet for us to input records. she
set the days up in the collumns and now we have run out of collumns is there
any way of easily transposing the information to rows without having to type
it all in again (we work with Excel 2000)
--
Thank you for reading my post. Hopefully you can answer my querie

Mike you are a true star thank you very much X
--
Thank you for reading my post. Hopefully you can answer my querie


"Mike" wrote:

Shazza,

Select all your data and click Copy
Select the top left cell where you want to past it but note this mustn't
overlap the copied data so it may be best to paste it to another sheet.

Click paste special and check the transpose box and your done.

Mike

"Shazza" wrote:

One of my work collegues created a spreadsheet for us to input records. she
set the days up in the collumns and now we have run out of collumns is there
any way of easily transposing the information to rows without having to type
it all in again (we work with Excel 2000)
--
Thank you for reading my post. Hopefully you can answer my querie

You can very easily switch from collumns to rows or viceversa by selecting a
rows area with the same or more cells than the columns, and then insert the
TRANSPOSE formula, selecting the array of cells, in the first row, and press
CTRL+ShIFT+ENTER.
You will get values and formulas, though not formats transposed.

i.e..- you have data in the columns A1 to J1. Then you select 10 or more
rows, and insert in the 1st row: =TRANSPOSE(A1:J1) and so press
[CTRL+ShIFT+ENTER]

BR
--
Excel Excel Excel Excel Excel Excel Excel Excel Excel Excel Excel Excel
Excel Excel Excel Excel Excel Excel Excel Excel Excel Excel Excel Excel Excel
Excel Excel Excel Excel Excel Excel Excel Excel


"Shazza" wrote:

One of my work collegues created a spreadsheet for us to input records. she
set the days up in the collumns and now we have run out of collumns is there
any way of easily transposing the information to rows without having to type
it all in again (we work with Excel 2000)
--
Thank you for reading my post. Hopefully you can answer my querie