I need to change the below table data in a format like:

the data in the excel is :
product name_id1 payout_id1 product name_id2 payout_id2
A $10 B $20
A $30 B $40

so on
I need to convert it in the below format like:
A $10
B $20
A $30
B $40

Hi

Excel VBA's Union method would help you .

http://www.cpearson.com/excel/BetterUnion.aspx

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)