Hi Max,

Your code works great, but for one row. I also have to get all the
other rows procesed and have them end up stacked on top of eachother
vertically

Lets say I have 24 rows running down, each with 3 cells running across
per day. The number of days will vary, and it can go on for up to 70
days, but the average is around 10 - 20

1 row of data, 3 cells per day, 20 days equals 20 rows, times howeer
many rows i have got.

row 1 1 2 4| 4 5 6 | 4 5 6 | 6 7 8 etc up to 70 days
row 2 8 8 9| 6 7 8 | 0 0 9 etc up to 70 days
row 3 3 5 6| etc up to 70 days
v
v
on down to as many as 300 rows




So I am looking for that magic formula that will make the data look
like this:

1 2 4
4 5 6
6 7 8
8 8 9
6 7 8
0 0 9
3 5 6

When only enough space is needed for the data that exists. Yes,
convceivably I would need vertical space for 300 rows time 70 days, or
21000 rows in a nice vertical column, but it is not likely I'll need
anything close to that. Also, the data once gone vertical needs to be
sorted, subtotalled, and charted as well, so the less space used the
better.

I could just do the =a1 thing, forcing all 21000 rows to statically
exist waiting for the data to arrive, but there has to be a better
way.

Thanks for your input. Always appreciated.

Txx




Max Wrote:
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
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php...o&userid=24776
View this thread: http://www.excelforum.com/showthread...hreadid=493109