Transposing Row Data To A Column of Cells

**cheiss8078** · 12-30-2006, 01:10 PM

I want to take row data and transpose it to a column similar to as shown below, but am not understanding how to write my TRANSPOSE formula. Can someone help?

A................................CD CE CF CG CH CI
9 48 2 60 55 64 29
.
.
.
.
.
252 48
253 2
254 60
255 55
256 64
257 29

**VBA Noob** · 12-30-2006, 01:15 PM

Hi,

Select the range then press Ctrl + C to copy.

Select the first cell where you want the data to go then right click in the cell and select paste special

Tick the transpose button and ok

VBA Noob

**cheiss8078** · 12-30-2006, 01:18 PM

Thanks, it worked like a charm...it's always so simple once you find someone who knows how.

Happy New Year!!

**VBA Noob** · 12-30-2006, 01:20 PM

No problem

Please don't post duplicate posts in future.

It just wastes everyone time

VBA Noob

**cheiss8078** · 12-30-2006, 01:40 PM

Sorry 'bout the second post. Was trying to simplify my original writing and didn't realize it had already posted...first time here.

Next question, the steps provided work great when only raw data is being transposed, but when I tried transposing a row of cells containing summation formulae, I ended up with a column full of #REF! messages.

Is there a way to transpose a row containing formulae to a column as well?