Transposing rows with common entries into several rows

Hello,

I am still trying to familiarise myself with Arrays, Transpose, VLOOKUP etc.... and I am trying to write a VBA micro to transpose Rows with common entries into several column.

Also, if someone has any recommendation about sites or books that deal specifically with arrays, index etc.. that would be much appreciated.



Thank you!

try

Please Login or Register  to view this content.

Thank you!

I works really well. I did not realised until now that I had so many missing entry.

Just one question. What would happen if there were a duplicated entry? I.e. two type 43 for the same "allocated_to_product_id"
Would the last entry simply overwrite the previous one?

I just checked and it does just that. Would it be any easy way to check for duplicated entry first?

Regards,
Didier

What do you want to do when duplicate happens?

Best would be to have a single line entry for the duplicates so the can easily be identified, investigated and corrected.

Something like that.

Doc4.jpg

Make it simple
Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

That works great. Thank you.

Accessing Application.Match method 15000 x 2 times.... joking.

What is the "Efficient" for you?

Writing like spaghetti code to reduce the space? if so, it may be...

Insult?

You always take my important message like that even you asked...