View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Atif Atif is offline
external usenet poster
 
Posts: 27
Default 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