On May 31, 3:29 pm, muggeschiss
wrote:
thank you very much, bj and vezerid! first suggestion works fine. i am trying
to understand vezerid's suggestion but do not know which argument to put in
the first ROW function.

"vezerid" wrote:
In B1:
=A1
In B2:
=IF(MOD(ROW()-ROW($A$1)+1,2)=1,A2,A1)

Select both rows and sort by B:B

Bj's solution will work. If you want to try my solution change $A$1
with the cell from which your data starts. Adjust the other two
references accordingly (e.g. if you start with A13 then- $A$13, A14,
A13). It has this construct to ensure that it will assign odd-even
rows correctly to the name or data.

HTH
Kostis