Hello. I have an excel list including some shoe products.
It is like this:
Product Code Product Name Size
12345 Shoe1 25
12345 Shoe1 26
12345 Shoe1 27
As you see it duplicate same product because of different sizes. I need a macro which will automatically convert this into this:
Product Code Prod?ct Name Size1 Size2 Size3
12345 Shoe1 25 26 27
If product codes are same, it must create new columns like Size2, Size3 etc. and write values into these cells.
This is in emergency. Please write I AM THE ONE in your bid so I can understand that you read requirements carefully.
Thank you very much for bidding.