Merging Common Rows in Excel into Multiple Columns?

Question

In Excel I need to merge common common rows into one row across multiple columns:

For example, this is my data:

ID Product Cost
1 ABC $5.00
2 DFG $4.00
1 FDG $3.00
3 DHJ $5.00
2 ASF $3.00
2 EFD $4.00


I need the merge to look like this:

ID Product Cost Product2 Cost2 Product3 Cost3 TOTAL COST
1 ABC $5.00 FDG $3.00 $8.00
2 DFG $4.00 ASF $3.00 EFD $4.00 $11.00
3 DHJ $5.00 $5.00


Thanks

Answer 1

You can do this with a macro but not by using a formula.

Answer 2

You need to use a pivot table my friend. I could go though all the shizz of how to create one, but google it for yourself. It's a topic that requires a full tutorial. Here's one to get you started.

http://www.timeatlas.com/5_minute_tips/chunkers/learn_to_use_pivot_tables_in_excel_2007_to_organize_data

Answer 3

Since that's not formulaic, you'll have to do it by hand.