Avatar of Wilder1626
Wilder1626
Flag for Canada

asked on 

Excel VBA - Convert liste into a concatenation list

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
Microsoft ExcelVBA

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon