How do I copy columns when part of formula has another sheet in it

How do I copy columns when part of formula has another sheet in it

Post by YW5kcmV3d2 » Tue, 06 Nov 2007 08:30:01


How do I copy columns when part of formula has another sheet in it?

I want it to formulate from row 1a, 2a, 3a, 4a, 5a, etc.
But the standard copy function goes 1a, 1b, 1c, 1d, 1e, etc.

Does this make sense?
 
 
 

How do I copy columns when part of formula has another sheet in it

Post by TWF4 » Tue, 06 Nov 2007 08:59:01

Source data assumed in Sheet1, starting in A2 across/down

In Sheet2,

Place this in any starting cell, say in B2:
=OFFSET(Sheet1!$A$2,COLUMNS($A:A)-1,ROWS($1:1)-1)
Copy across and fill down as desired to populate a "transpose" view of the
source data in Sheet1.
--
Max
Singapore
http://www.yqcomputer.com/
xdemechanik
---