Hello!
I am Branislav and I can help you create a list. However, I do not see this is possible with formulas, so, yes, you are right - a macro will be needed for this. It will need to loop through the records and extract the data. I will need one day to write a macro, two at most.
Regards,
Branislav Mihaljev