Nov 20 2021 04:16 PM
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 | A015827 |
5/06/2014 | A015830 |
5/06/2014 | A015831 |
5/06/2014 | A015832 |
5/06/2014 | A015833 |
16/06/2014 | A015760 |
16/06/2014 | A015834 |
16/06/2014 | A015854 |
16/06/2014 | A015855 |
16/06/2014 | A015857 |
16/06/2014 | A015858 |
Into this:
Date | Code 1 | Code 2 | Code 3 | Code 4… |
5/06/2014 | A015826 | A015827 | A015830 | A015831 |
16/06/2014 | A015760 | A015834 | A015854 | A015855 |
Can someone help me to describe what I'm trying to do?
Thanks.
Nov 20 2021 09:18 PM
SolutionF2
="Code "&SEQUENCE(,MAX(COUNTIFS(tbl_Data[Date],E3#)))
E3
=UNIQUE(tbl_Data[Date])
F3
=TRANSPOSE(FILTER(tbl_Data[Code],tbl_Data[Date]=E3))
Nov 21 2021 12:45 AM
Nov 20 2021 09:18 PM
SolutionF2
="Code "&SEQUENCE(,MAX(COUNTIFS(tbl_Data[Date],E3#)))
E3
=UNIQUE(tbl_Data[Date])
F3
=TRANSPOSE(FILTER(tbl_Data[Code],tbl_Data[Date]=E3))