Forum Discussion
Automatic table
Hi! I need help with creating a table. In sheet 1, I have my data. I want to transfer the names under Column A to the table on Sheet 2, and are categorized according to the identified labels. I'm try...
Depends on which version of Excel you are. For such transformation
in J2 it could be
=TRANSPOSE(UNIQUE(F2:F7))in J3
=FILTER($A$2:$A$7,$F$2:$F$7=J$2,"")and drag it to the right.