hi,
i have some data as follows:

A B C
1 abc xyz 15 (as a group of data)
2 hij 20
3 qwe wer 17

i want a result
A B
1 abc 15
2 xyz
3 -space-
4 hij 20
5 -space-
6 qwe 17
7 wer

is there any ideas how to write marco to solve it?
TIA
norik

--
norik
-----------------------------------------------------------------------
norika's Profile: http://www.excelforum.com/member.php...nfo&userid=487
View this thread: http://www.excelforum.com/showthread.php?threadid=49633