Custom Collection, dynamic width?

[dcaudill1]

I have a custom collection consisting of 3 components, the 3rd component will have a varying number of elements. To make it visible, column A and B will always be the first 2 elements in my variant array. Column C and potentially D,E,F are all of 3rd component "type". I'm at a loss as to how I should manage this. I already have established my jagged array, and I can likely operate the macro like that, but I would prefer setting up a custom collection. Ideas?

 

[dcaudill1]

To clarify, I do not know how many columns (width) will be required, I need this to be dynamic.

 

[dcaudill1]

Let me provide a better explanation. I have a custom collection with 3 object properties. Name, Sub Name, and Currency. Each record will have one name and one sub name, but a varying number of Currency. Some items may have 4 currency, while others may only have 1. I want to avoid setting up object property .Currency1, .Currency2, etc. Is there a way to effectively manage this?