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?
