List a group of repeated data from sheet1 to sheet2 but not repeat
 

--
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.

List a group of repeated data from sheet1 to sheet2 but not repeat
 

Check your other post for a non-macro suggestion.

Please don't multipost to several newsgroups.

If you think you have to post to lots of newsgroups, then send one message to
all the newsgroups--instead of sending single messages to each group separately.

Tasmania wrote:

--
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.

--

Dave Peterson