transposing

F

Frank Kabel

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

Jay

pl said:
How to transpose rows and columns with unequal numbers of
cells ?
Click to expand...

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."
 
G

Guest

-----Original Message-----
Hi
could you explain what you mean with 'unequal'.
You may have a look at the TRANSPOSE function
Click to expand...
I mean a rectangular range of cells.
pl
 
F

Frank Kabel

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

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
 
G

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
 
J

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?
Click to expand...

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

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 ########.
Click to expand...

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
 
Top