Hello all,
I am real beginner in Power Query, knowing to do just basic stuffs... But right now i am in front of a problem where i think i can use Power Query, but i am blocked
So i have the attached table and since in the end i will have to print a sheet with today values, i think that the "easiest" solution would be transpose in power query. But it seems harder than i believed in the first place.
On the attached table, sheet "from" contains the table i have right now and sheet "to" contains the dates that i need to be exported by power query. I tried to user transpose with unpivot columns... but the result was a total mess
In the end i will use a formula to get the dates from today, for all parts and print it.
Do you think this can be done? Should i use another solution? Any help is highly appreciated.
Thank you for your time![]()
Bookmarks