I'm looking to return a single cell of values that show results matched against one column which are then used to collect their own results. Much easier to explain with a display...
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Clothing[/TD]
[TD]Colour[/TD]
[TD]Place[/TD]
[/TR]
[TR]
[TD]Hat
[/TD]
[TD]Red[/TD]
[TD]Head[/TD]
[/TR]
[TR]
[TD]Hat[/TD]
[TD]Yellow[/TD]
[TD]Head[/TD]
[/TR]
[TR]
[TD]Glove[/TD]
[TD]Red[/TD]
[TD]Hands[/TD]
[/TR]
[TR]
[TD]Scarf[/TD]
[TD]Blue[/TD]
[TD]Head[/TD]
[/TR]
[TR]
[TD]Glove[/TD]
[TD]Green[/TD]
[TD]Head[/TD]
[/TR]
[TR]
[TD]Hat[/TD]
[TD]Red[/TD]
[TD]Neck[/TD]
[/TR]
[TR]
[TD]Glove[/TD]
[TD]Red[/TD]
[TD]Head[/TD]
[/TR]
[TR]
[TD]Scarf[/TD]
[TD]Yellow[/TD]
[TD]Hands[/TD]
[/TR]
</tbody>[/TABLE]
I would like to display each variation of colour and place for an item of clothing combined with the following syntax in a single cell
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Clothing[/TD]
[TD]Combined[/TD]
[/TR]
[TR]
[TD]Hat[/TD]
[TD]Red[Head,Neck],Yellow[Head][/TD]
[/TR]
[TR]
[TD]Glove[/TD]
[TD]Red[Hands,Head],Green[Head][/TD]
[/TR]
[TR]
[TD]Scarf[/TD]
[TD]Blue[Head],Yellow[Hands][/TD]
[/TR]
</tbody>[/TABLE]
Is this possible without VBA? I thought I might be able to do some sort of nested array formula using TEXTJOIN but I'm completely stuck now?
Any help massively appreciated!
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Clothing[/TD]
[TD]Colour[/TD]
[TD]Place[/TD]
[/TR]
[TR]
[TD]Hat
[/TD]
[TD]Red[/TD]
[TD]Head[/TD]
[/TR]
[TR]
[TD]Hat[/TD]
[TD]Yellow[/TD]
[TD]Head[/TD]
[/TR]
[TR]
[TD]Glove[/TD]
[TD]Red[/TD]
[TD]Hands[/TD]
[/TR]
[TR]
[TD]Scarf[/TD]
[TD]Blue[/TD]
[TD]Head[/TD]
[/TR]
[TR]
[TD]Glove[/TD]
[TD]Green[/TD]
[TD]Head[/TD]
[/TR]
[TR]
[TD]Hat[/TD]
[TD]Red[/TD]
[TD]Neck[/TD]
[/TR]
[TR]
[TD]Glove[/TD]
[TD]Red[/TD]
[TD]Head[/TD]
[/TR]
[TR]
[TD]Scarf[/TD]
[TD]Yellow[/TD]
[TD]Hands[/TD]
[/TR]
</tbody>[/TABLE]
I would like to display each variation of colour and place for an item of clothing combined with the following syntax in a single cell
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Clothing[/TD]
[TD]Combined[/TD]
[/TR]
[TR]
[TD]Hat[/TD]
[TD]Red[Head,Neck],Yellow[Head][/TD]
[/TR]
[TR]
[TD]Glove[/TD]
[TD]Red[Hands,Head],Green[Head][/TD]
[/TR]
[TR]
[TD]Scarf[/TD]
[TD]Blue[Head],Yellow[Hands][/TD]
[/TR]
</tbody>[/TABLE]
Is this possible without VBA? I thought I might be able to do some sort of nested array formula using TEXTJOIN but I'm completely stuck now?
Any help massively appreciated!