I have this excel file where i have 4 column of data:
NAME
TYPE
VALUE
BASE_LINE
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.
Example:
If i have this in my sheet called LIST:
![LISTE sheet]()
Once the macro ran, i will get this result:
![Result]()
How can i do that?
I can have more than 1000 records, all sorted by NAME, TYPE, BASE_LINE.
Thanks for your help