Hi I have a list of cells (one under the other) and I'm looking for a
way to "manually transpose" them to another sheet.What happens is that
every 4th cell I want to change row.

e.g.

Sheet1
r1: 1
r2: 2
r3: 3
r4: 4
r5: 1
r6: 2
r7: 3
r8: 4


Sheet2
c1 c2 c3 c4
1 2 3 4
1 2 3 4


How can i do it?


--
ckotsis
------------------------------------------------------------------------
ckotsis's Profile: http://www.excelforum.com/member.php...o&userid=31759
View this thread: http://www.excelforum.com/showthread...hreadid=514834