I have one excel sheet1 look like the following:

UserName Location Division Software Name Version

Maria.Sigmu Parkade Probation Adobe Reader 7.0
Maria.Sigmu Parkade Probation Lotus Notes 6.5.5
Eric.Bell Parkade IT WebFldrs 1.0
Eric.Bell Parkade IT Adobe Reader 7.0
Eric.Bell Parkade IT Symantec 8.1

I want to create sheet 2 using Excel Macro in the following
format:

UserName Location Division Software Name Version

Maria.Sigmu Parkade Probation Adobe Reader 7.0
Lotus Notes 6.55
Eric.Bell Parkade IT WebFldrs 1.0
Adobe Reader 7.0
Symantec 8.1

I am a novice user in Excel VBA. I greatly appreciate any help.

--
thadi