Converting data from 4 columns in 1 row into a new value

[djfscouse]

Hi,

I'm in need of a way to convert data from each row to an item number, I have attached an example of a what I'm currently using but I need it the exact opposite.

The code below is writing 39.3, 51, 31, 7 each time there is MPG-PB01, but I need the opposite which is to write MPG-PB01 each time there is 39.3, 51, 31, 7

Please Login or Register  to view this content.

And I'm using excel 2003

Hope this makes sense and that somebody can help.

Thanks anyway,

David

[djfscouse]

Solved with the help of a friend, so I put the code below in case it can help somebody else.

Please Login or Register  to view this content.