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.
An alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.