How to perform "group by"?

[thlee1122]

Hi all,

I have a quick question about performing "group by" in excel.
I currently have to 2 columns named, "name"' and "number" as shown below.

Name Number
Balance 2000
Balance 300
Balance 200
Sales Deduction 20
Sales Deduction 30
ROI 20
ROI 10
Balance 29
Sales Deduction 1000
ROI 90
Sales Deduction 299
ROI 15

I would like to change above table into one below.
I would like to "group" the rows by their names.

Balance Sales Deduction ROI
2000 20 20
300 30 10
200 1000 90
29 299 15

Can you please help me with this?
This is a very urgent matter.


Thank you.

 

[Macropod]

Cross-posted at: How to perform "group by"?
Please read our policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html