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 | 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.
F2 ="Code "&SEQUENCE(,MAX(COUNTIFS(tbl_Data[Date],E3#))) E3 =UNIQUE(tbl_Data[Date]) F3 =TRANSPOSE(FILTER(tbl_Data[Code],tbl_Data[Date]=E3))
2 Replies
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.
