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.

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

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.

  • 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.