Forum Discussion
troyhimes
Resolver I
Resolver IPossible 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 lo...
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.
troyhimesResolver I
Resolver IThanks lbendlin ! I used the same approach that you suggested and found this tutorial helpful (Unpivot and Combine Data from Multiple Tables using Power Query )