Transpose Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I enumerate and transpose all cells in a range (array).

here is my range (before) ("A1:B4"):

A B
-- --
1 2
3 4
5 6
7 8

what i want do to is transpose to Column C like this

C
--
1
2
3
4
5
6
7
8

Thanks
w
 
Put this formula in C1, then drag fill down

=OFFSET($A$1,ROUNDDOWN((ROW()-1)/2,0),MOD(ROW()+1,2))

If you want hard coded number, then select column C and do Edit=>Copy, then
immediately Edit=>Paste Special and select values.
 
Thanks Tom this is great stuff and it works..., but I
wonder if you had anything on how to implement this via VBA Code?

Thanks,
w
 
Back
Top