I have this excel file where i have 4 column of data:
The same name can show more than once but would always have the same TYPE and VALUE, but different BASE_LINE.
What i would try to do is to have 1 record row per NAME by concatenating the TYPE only once, the VALUE only once and then all the BASE_LINE.
If i have this in my sheet called LIST:
Once the macro ran, i will get this result:
How can i do that?
I can have more than 1000 records, all sorted by NAME, TYPE, BASE_LINE.
Thanks for your help