Forum Discussion
Solved
Help transposing one column and grouping by another at the same time?
I think I'm having trouble finding the answer to this because I don't know what to call it, but an example makes it clear. I want to turn this: Date Code 5/06/2014 A015826 5/06/2014 A015...
F2 ="Code "&SEQUENCE(,MAX(COUNTIFS(tbl_Data[Date],E3#))) E3 =UNIQUE(tbl_Data[Date]) F3 =TRANSPOSE(FILTER(tbl_Data[Code],tbl_Data[Date]=E3))
F2
="Code "&SEQUENCE(,MAX(COUNTIFS(tbl_Data[Date],E3#)))
E3
=UNIQUE(tbl_Data[Date])
F3
=TRANSPOSE(FILTER(tbl_Data[Code],tbl_Data[Date]=E3))
Once I worked out how to put in the correct arrays where you had 'tbl_Data[column]', this worked. Very much appreciated, thanks.