Forum Discussion
Splitting column items into new columns
Hello all, I have a list like in below (example) and I need to split "Year" column into new columns. It means, I need to show yearly score of each city in the columns (like 2019-2020-2021-2022-2...
Do you mean you need to Pivot the table? Not sure if I am understanding the query correctly? If I am.... Select the year column, then pivot by value