Convert multiple columns for each year of data into a single column and date column

[ScottF]

Hi @zm004433 and welcome to the forum.

Try this workflow out and see what you think. It works on your sample data, but I think it should be fairly extensible to your larger dataset. The trick is making sure you understand how the configuration of the Unpivoting and Pivoting nodes work.

UniversityDataUnpivotExample.knwf (12.3 KB)