Vlookup - multiple results into one cell

[mkyb14]

I've been hunting around google and forums trying to figure this out out using a formula vs VBA. I'm using google sheets currently for this.

ColA - Account ID / ColB - Customer Name / ColC Customer sub accounts (ranges from 1-15 separate names)

Another sheet contains all the customer record numbers and their subsidiaries.

• Account ID | Acme | sub 1 | sub1.Record#
• Account ID | Acme | sub 2 | sub2.Record#

So for example Acme is the Parent account (referenced by ColA), but I need to truncate all their subsidiaries in the cell to the right of them within a master file.

• Acme | Sub1,sub2 | sub1.Record, sub2.Record |

Is this possible with out using VBA?

Matching my list of customer account ID's and condensing down another sheets results of the customer subsidiaries in a cell for quickly seeing the subs.

 

[bobsan42]

I am not sure I get it completely, but why fit it all in one cell?
Pivot tables can present it quite well I think.