Forum Discussion
Solved
Extracting common data into columns
Hi, I wonder if anyone can help explain how I can create an alternative view for a big data set I have. For the sake of this question, I have created an illustration of what I am trying to a...
Let's say the first sheet is named Data Sheet.
In A1 on the second sheet, enter the formula
=TRANSPOSE(SORT(UNIQUE('Data Sheet'!A2:A9)))
In B1:
=FILTER('Data Sheet'!$B$2:$B$9,'Data Sheet'!$A$2:$A$9=A1)
Fill to the right.
See the attached demo workbook.
Let's say the first sheet is named Data Sheet.
In A1 on the second sheet, enter the formula
=TRANSPOSE(SORT(UNIQUE('Data Sheet'!A2:A9)))
In B1:
=FILTER('Data Sheet'!$B$2:$B$9,'Data Sheet'!$A$2:$A$9=A1)
Fill to the right.
See the attached demo workbook.
Thank you so much for everyone's responses, this one worked perfectly!!
