|
How do I keep letters the same and change the # for drag formula
I want to have the columns do the following
A1 b1 A2 b2 A3 b3 When I drag/drop they go A1 A2 B1 b2 C1 c2 What formula can I use to reorientate my data? |
How do I keep letters the same and change the # for drag formula
If it's to be done somewhere else on the same sheet as the source range, one
way is just to place in any starting cell: =OFFSET($A$1,COLUMN(A1)-1,ROW(A1)-1) then copy across and fill down as far as required This will achieve a dynamic transpose of the source range -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "ASST" wrote: I want to have the columns do the following A1 b1 A2 b2 A3 b3 When I drag/drop they go A1 A2 B1 b2 C1 c2 What formula can I use to reorientate my data? |
How do I keep letters the same and change the # for drag formu
=OFFSET($A$1,COLUMN(A1)-1,ROW(A1)-1)
The "$A$1" would be the OFFSET's reference point, ie the top left cell in the source range. Easily adapt this to suit - just point to the particular source range's top left cell (if it's other than A1). -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Max" wrote: If it's to be done somewhere else on the same sheet as the source range, one way is just to place in any starting cell: =OFFSET($A$1,COLUMN(A1)-1,ROW(A1)-1) then copy across and fill down as far as required This will achieve a dynamic transpose of the source range -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "ASST" wrote: I want to have the columns do the following A1 b1 A2 b2 A3 b3 When I drag/drop they go A1 A2 B1 b2 C1 c2 What formula can I use to reorientate my data? |
| All times are GMT +1. The time now is 04:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com