transposing

[pl]

How to transpose rows and columns with unequal numbers of
cells ?

 

[Frank Kabel]

Hi
could you explain what you mean with 'unequal'.
You may have a look at the TRANSPOSE function

 

[Jay]

How to transpose rows and columns with unequal numbers of
cells ?

First, select the area to be transposed, as a rectangle of cells.

Then use
Edit >> Copy

Then find an empty area in a worksheet where you want to put the results.

Select the cell at the upper left corner of that area.

Then use
Edit >> Paste special
and check the box that says "Transpose."

 

[Guest]

-----Original Message-----
Hi
could you explain what you mean with 'unequal'.
You may have a look at the TRANSPOSE function

I mean a rectangular range of cells.
pl

 

[Frank Kabel]

Hi
just select a target range of the correct size (e.g. A16 if your
source range is A1:F4) and enter the following array formula (entered
with CTRL+SHIFT+ENTER)
=TRANSPOSE('source_sheet'!A1:F4)

 

[Guest]

I use a range of four coloumns and eight rows excluding
row/column heading. I can't get the good result after
transposing. According to Microsoft Excel Help, transpose
can only work on range of equal number of columns and rows.
Is there a work around?
pl

 

[Guest]

No Luck , Frank. I tried your method and I didnot get the
result I want. Jay 's solution is the same as PC
annoyances's tip. It was a bit better but I could get the
column total after transposing , all I got was ########.
regards
pl

 

[Guest]

Sorry Frank, it works according to your tip. Thank you very
much.
pl

 

[Jay]

First, select the area to be transposed, as a rectangle of cells.

I use a range of four coloumns and eight rows excluding
row/column heading. I can't get the good result after
transposing. According to Microsoft Excel Help, transpose
can only work on range of equal number of columns and rows.
Is there a work around?

I use Excel 97 and it works for me. What goes wrong for you?

 

[Jay]

wrote:

... Jay 's solution is the same as PC
annoyances's tip. It was a bit better but I could get the
column total after transposing , all I got was ########.

When you see ######## it means that the cell is too narrow. You can either
widen the column or (for text) use
Format >> Cells >> Alignment >> Wrap text