I would probably check into using Mail merge to get it into your desired
layout.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out:
www.ExcelUserConference.com
"MUSTANG" wrote in message
...
I have a difficulty about obtaining following:
Existing situation:
column1 column2
row1 A1 PNT1
row2 A4 PNT5
row3 A2 PNT12
row4 A3 PNT8
Converted condition:
A1 A2
PNT1 PNT12
A3 A4
PNT8 PNT5
WHAT SHOULD I DO FOR THAT?