Forum Discussion
Load& Combine + Unpivot
hi Team, i have monthly excel files that contains a forecast for some items, each item has a code and descrition. the table i recieve monthly contain first column called "code", second column ca...
Hi ahmadhlawa ,
For combining files,you can use "append",here is a reference.
For "unpivot",you can refer to:
https://radacad.com/pivot-and-unpivot-with-power-bi
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
v-kelly-msft i'm loading files from a sharepoint folder, and each month i recieve a new file in the same folder.
i'm afraid its not practical to do this process each month.
