I have data this way:
Account | Category | Date
12 | Phone | 01/01/22
12 | TV | 01/01/22
13 | Phone | 01/02/22
12 | TV | 01/01/22
I would like to figure out on each date the counts for each subcategory. First i would want the data pivoted this way:
Account | Category | Date
12 | Phone, TV | 01/01/22
13 | Phone | 01/02/22
Or to where the categories would be split into columns.
Is this possible? Then I could make a formulae to say which customers have what services on a particular date.