Hi,

Source data is in following form, depending on the user reqirement, I want
to creat a Packate Code, i.e. Standard Desktop (A), Standard Desktop with
Monitor (B), Standard Laptop (C). Standared Laptop with Monitor (D)

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 with
Standard 17" Monitor

Result will be:
A B
10 BILINSKI, JOHN B
11 ZMIJOWSKYJ, MIKE C
12 MOORE, LIZ A
13 CHEUNG, JULIANA D

Regards

Atif