Forum Discussion

troyhimes's avatar
troyhimes
Icon for Resolver I rankResolver I
4 years ago
Solved

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 lo...
Need Help
  • lbendlin's avatar
    lbendlin
    4 years ago

    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.

troyhimes's avatar
troyhimes
Icon for Resolver I rankResolver I
4 years ago

lbendlin , 2 columns in Feb were missing the headers, they are there now

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

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.