Help transposing one column and grouping by another at the same time?

[bpalmerau]

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.

[#2 · Accepted solution]

@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))

[#3]

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