Power Platform Community Forum Thread Details

Hi community,

I have a set of data in a SharePoint list that is in this format:

I need to transform this into a table that then looks like this:

I'm currently doing this by:

Duplicating the base table
Removing the columns from the other year and salary columns that I don't need to pivot
Pivoting the year and salary columns
Repeat for each year
Appending all the tables back together at the end

Curious to know if there is a way automate this rather than having to create each table?

Cheers

Carl

Categories:

Auto create tables based on variables