Forum Discussion
TeeGee
Helper II
Helper IIHow to load multiple excel files from a folder & unpivoting dynamic (differs per file) # of columns
I have a folder with multiple Excel files, each with some common leading columns, and then a varying (per file) number of columns that I need to unpivot; I've written the code for unpivoting properl...
Hi TeeGee ,
Can you please share some sample data to help us clarify your table data structure to help use calcify your scenario? It is hard to direct test on m query formula without any sample data.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng