transposing cells through cut command - help needed! :)

A

Alla

Hello,

I have a worksheet in which cells are arranged with headers in
Column1. I need to arrange them to be in Row1. The problem is that I
have other worksheets linked to this worksheet, so if I use a copy
command, those links would still refer to a previous range and not to
the "copied range".

Does anyone know how to deal with this problem?
I have seen replies below to similar problems, but I don't believe
that mine will be resolved through solution below, because formulas in
other worksheets would still be linked to Sheet1 and not to the sheet
into which I pasted the formula below: =TRANSPOSE('sheet1'!A1:AN6)

Thanks a lot!
Alla



Hi
one way: if your data is on sheet1 (starting in cell A1) try the
following on a separate sheet:
- select a range of 6 columns and 40 rows (e.g. A1:F40)
- click into the formula bar and enter the array formula
=TRANSPOSE('sheet1'!A1:AN6)
- finish this formula with CTRL+SHIFT+ENTER
 
F

Frank Kabel

Hi
I think you have to change your other formulas. No way to do this
automatically
 
Top