Assuming source data is in Sheet1, in A1 across ..

In Sheet2,
Put in say, A1: =INDEX(Sheet1!$1:$1,,COLUMN(A1)+ROW(A1)*3-3)
Copy A1 across to C1, fill down until zeros appear
signalling exhaustion of data extracted from Sheet1's row1

(If the source data runs right across in A1:IV1 in Sheet1, we could fill
A1:C1 down till C86 [max], with A86 returning the last, rightmost value in
Sheet1's IV1. B86 and C86 would return #REF! errors)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"tx12345" wrote in
message ...


=INDIRECT("Sheet1!"&"R"&1+INT((ROW()-1)/3)&"C"&(3*MOD(ROW()-1,3)+COLUMN()),F
ALSE)

nice formula, but it only works with 3 sets (abc, def, ghi) I have up
to 70 sets of three to track. I have tinkered with the formula, but no
matter what i do it screws it up. If i leave it alone it only picks up
the three sets, abc, def, ghi. Any way to expand the formula to
include up to 70 sets of three, i.e., jkl, mno, pqr etc etc etc

Thx


--
tx12345
------------------------------------------------------------------------
tx12345's Profile:
http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=493109