Sort and combine 2 sets of data in excel

[waiwera]

Hi Guys, i'm newbie with excel 2010.
i wanna sort 2 sets of data as follow:
Name Amount Name Amount
aaa 100 ccc 200
ccc 100 bbb 100
ddd 200 aaa 300
eee 100 fff 100
ggg 500 hhh 100

the result i expect will be:
Name Amount Name Amount
aaa 100 aaa 300
_______bbb 100
ccc 100 ccc 200
ddd 200
eee 100
________fff 100
ggg 500
________hhh 100


please kindly advise if any simple way to do this.
really appreciate your kindness help.
cheers

 

[oldbrewer]

combine the data so that all data is in 2 columns with letters in first column, then sort ascending - then see how to reformat it

 

[waiwera]

combine the data so that all data is in 2 columns with letters in first column, then sort ascending - then see how to reformat it

thanks for the advice, mate. however i want the result stays in 4 columns.
i found a solution from another web to use ISNA and Vlookup and it seems to work
i'll try to play around the formula. cheers all

<code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: inherit;">=IF(ISNA(VLOOKUP($A10;$D$3:$E$6;1;0));"";VLOOKUP($A10;$D$3:$E$6;1;0))=IF(ISNA(VLOOKUP($A10;$D$3:$E$6;2;0));"";VLOOKUP($A10;$D$3:$E$6;2;0))</code></pre>The idea behind this is to use <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; color: rgb(0, 0, 0); line-height: 17.804800033569336px;">VLOOKUP</code> to find cells that match the values in column A. If a matching cell is not found (i.e., the <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 14px; vertical-align: baseline; background-color: rgb(238, 238, 238); font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; color: rgb(0, 0, 0); line-height: 17.804800033569336px;">VLOOKUP</code> function returns an N/A value), put an empty string into the cell contents. If a matching cell is found, put the VLOOKUP result into the cell contents.