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 achieve.
There are two columns (Category & Value) in a data set that I need to appear on a separate sheet, but instead the Category needs to be the column title and the values that fall within this category listed below it – is this possible please?
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 achieve. There are two columns (Category & Value) in a data set that I need to appear on a separate sheet, but instead the Category needs to be the column title and the values that fall within this category listed below it – is this possible please? Read More