Bundling Hardware Request
 

Hi,

Source data is in following form, I want to bundle them to create a summary.
.. How, I do not have any idea.

Will assigning codes i.e. Standard Desktop (A), Standard Desktop with
Monitor (B), Standard Laptop (C). Standared Laptop with Monitor (D) will work

Source:
A B
1 User Name Hardware
2 BILINSKI, JOHN Standard Desktop
3 Standard 17" Monitor
4 ZMIJOWSKYJ, MIKE Standard Laptop
5 MOORE, LIZ Standard Desktop
6 CHEUNG, JULIANA Standard Laptop
Standard 17" Monitor

Summary:

A B
C D
Standard Desktop Standard Desktop
Standard 17" LCD
1 Bundle with 17" LCD Bundle No Monitor
Laptop: Monitor
Flat Panel Monitor:
2 BILINSKI, JOHN 1
3 ZMIJOWSKYJ, MIKE
1
4 MOORE, LIZ 1
5 CHEUNG, JULIANA
1 1