Do you mean like STRING_AGG (Transact-SQL)?

Which sources?

It looks like it would be the same as example D in the link you provided. The source is a query 4th in line to widdle down to the information needed and sorted. I will try to put a sample set of data but essentially the query consists of "RetailItemName", "ItemCategory", and "SumofgWeight" sorted by weight. There are multiple identical values in RetailItemName with single returns for ItemCategory (ultimately they are ingredients). If I were making a simple report I would argue I am done and put in a group header on a report for RetailItemName and then ItemCategory would be the records. That won't work for my end result because of the use for this 'report'.

After finally getting chatgpt to stop procastinating (no money for paid use so stuck with the limits of free). I did manage to get what I needed. It doesn't seem like it can be done without VBA period. I will post the code and the query calling it to show what the solution was. I don't fully understand the code which is why I was hoping someone had a solution without but thought it might be helpful to put up. I'll be glad when I get more developer lessons under my belt.

Sorry, realized much later that I should probably provide a screenshot of the result so everyone can see. Also, thank you Alex for trying to help. Also happened to do a quick search to see if this was covered anywhere between stringagg (couldn't find before but double checked tonight) and concatrelated. It doesn't look like it's been covered before, would anyone know if I overlooked something?