Ok, I've searched conversations and not found my answer, and spent way too much effort solving what should be an easy point and I 'know' I'm just missing it. The below isn't the real data, but this is short easy and follows same concept, my real data set is much too large.
I want to flip this with and use Car & Home as column headers: 1 row per each data set per day
Day Place Mood
Mon Home happy
Mon Car sad
Tue Home sleepy
Tue Car sleepy
Wed Home happy
Wed Car happy
Thu Home quiet
Thu Car happy
Fri Home bored
Fri Car mad
Mon Home mad
Mon Car bored
Tue Home happy
Tue Car quiet
Wed Home happy
Wed Car happy
Thu Home sleepy
Thu Car sleepy
Fri Home happy
Fri Car sad
My real data set has more than 2 columns, and real answers are more than 4. I know there has to be an easy answer I'm missing. Transpose / Crosstab doesn't work with 'first' or 'concatenate'.
Thoughts?
Solved! Go to Solution.
Hi @Watermark ,
Here it is.
Since you don't have an unique ID for each day, I've used a multi-row tool to generate it. But if you have a date column, you can use the tile tool to generate this ID as well.
This ID is needed to work as a key field in cross-tab tool.
Best,
Fernando Vizcaino
So effectively you add an ID for each 'group' of records . In my example it was a day, but for my real set, I just need to determine a pattern for the count.
I think that works.
An ace just answered with effectively same solution. Multi-row create ID for each record grouping. Thanks!