Multiple inputs into one output

[westex96]

Hi,

I am having a hard time to create a macro that will format the following in excel. I have 20000 inputs like this.

SECTOR MAIO
TX00021 3
TX00021 2
TX00021 1
TX00021 0
TX00022 0
TX00022 2
TX00022 1
TX00023 2
TX00023 1
TX00023 0

TO the following.

SECTOR MAIO
TX00021 3 2 1 0
TX00022 0 2 1
TX00023 2 1 0

Any help will be greatly appreciated.

Thanks!

Ray

 

[genomon]

Visual Basic versions 5 and 6 do not support macros. You may have better luck in one of the Office or VBA forums.

"Teamwork means never having to take all the blame yourself."

 

[westex96]

Thank you