Forum Discussion

Copper Contributor

Nov 21, 2021

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...

excel

Detlef_Lewin

Nov 21, 2021

bpalmerau

F2
="Code "&SEQUENCE(,MAX(COUNTIFS(tbl_Data[Date],E3#)))

E3
=UNIQUE(tbl_Data[Date])

F3
=TRANSPOSE(FILTER(tbl_Data[Code],tbl_Data[Date]=E3))

Detlef_Lewin

Silver Contributor

Nov 21, 2021

bpalmerau

F2
="Code "&SEQUENCE(,MAX(COUNTIFS(tbl_Data[Date],E3#)))

E3
=UNIQUE(tbl_Data[Date])

F3
=TRANSPOSE(FILTER(tbl_Data[Code],tbl_Data[Date]=E3))

bpalmerau
Copper Contributor
Nov 21, 2021
Once I worked out how to put in the correct arrays where you had 'tbl_Data[column]', this worked. Very much appreciated, thanks.