Forum Discussion
Possible to Unpivot multiple Gantt Charts?
Ok, well not actual Gantt charts but Excel tables created to function like Gantt charts. The input files are separate Excel files containing a schedule for each month saved to a single sharepoint location. I have multiple years worth of data in this same format. The goal is to unpivot the date columns data, which of course can be done to each individual file, but is there any possible way to do it in bulk to multiple months? The link is to a folder with 2 months worth of data. I want to keep those rows where the 'SUM PLAN' rows have a value since they are the activities that are scheduled in that given month.
See attached for the general approach. One function to read an Excel file, and another query that lists files in a folder and then calls the above function on all of them.
4 Replies
Thank you for the source files. Unfortunately they are not consistent. The column "RTP" is missing in one of the samples. Files must have the same structure before the Unpivot point.
Thanks lbendlin ! I used the same approach that you suggested and found this tutorial helpful (Unpivot and Combine Data from Multiple Tables using Power Query )
