I have several dimensions that have the same possible values: "True", "False", "Unknown". The data is shown below
What I'd like to do is use the dimensions (Wealthy, Tall, PlaysGolf) as row labels, and use the dimension values (True, False, Unknown) as Column headers. It should look something like the following:
Is this possible? I've attached a workbook with the excel sheet attached.
Thanks for your assistance.
If you want to do this dynamically, you really need to restructure your data so it's a true set of pair combinations.
Person, Attribute, Value
Mike, Weathy, True
Mike, Tall, False
Mike, PlaysGolf, True