I wonder if anyone knows if it is possible to subdivide an Excel file into several sheets from Power Query.
I mean, the result of the query to be loaded in different sheets, according to a segmentation.
I would like to illustrate this with an example:
We have a file in which there is information of 15 clients, the idea would be that the result of the query be separated in 15 sheets, according to the name of the "Client".
The number of clients could be variable.
Thank you very much!