Allen Browne's ConcatRelated function, is there a way to nest/alter this?

[offie]

Please excuse me, I don't know much about coding;

So I was wondering if I could somehow get the function to pull from 2 fields and display them within the same comma space:

Example:
Initial Field;
1 l a l big
1 l b l small
1 l c l tiny
2 l a l jumbo
2 l b l large

I want to get;
1 l (a) big, (b) small, (c) tiny
2 l (a) jumbo, (b) large

It doesn't have to have parentheses, just something to differentiate them.

I'm not sure is this is something moderately simple that means just chaning the expression or something way more complicated that means changing the VBA code.
Has anyone done something like this?

Thanks!

[rpeare]

want to link the thing you're referencing from allen browne?

[offie]

Sure its http://allenbrowne.com/func-concat.html
But... I ended up figuring it out, much more simple than I though

ConcatRelated(" '(' & TradeCode & ') ' & Name","Contractor1",("[ProjectCode] =""" & [ProjectCode] & """"))

Just using
'(' & TradeCode & ') ' & Name
As the stringField, " " Didn't work but for some reason ' ' worked