--
thadi

I have one excel sheet1 look like the following.

UserName Location Division Software Name Version

Maria.Sigmund Parkade Probation Adobe Reader 7.0
Maria.Sigmund 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 AntiVirus
8.1

I want to modify this sheet1 to sheet 2 using Excel Macro in the following
format:

UserName Location Division Software Name Version

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

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