Data collation
 

I have two large spreadsheets of data which i want to use to create one
spreadsheet of data.


Spreadsheet one
Spreadsheet two

A B C
A B
1 A-401-5000 120222 31/10/07 1 A-400-5000
63.00
2 A-400-3434 122112 29/07/06 2 A-400-5656
100.00
3 A-400-7272 123232 20/07/04 3 A-400-3434
235.00

4 A-400-7272 500.00


What i want to acheive is a spreadsheet that will give me the following data

A B C D
1 A-401-5000 120222 31/10/07 63.00
2 A-400-3434 122112 29/07/06 235.00
3 A-400-7272 123232 20/07/04 500.00
4 A-400-5656 100.00


Any ideas on how i can acheive this, i though maybe a pivot table but i
can't seem to get this to work.

Thanks