Forum Discussion
How to Expand all columns using loop ExpandTableColumn with a loop
Hello Power Bi expert, 🙂 this is my Excel table i would like to analyse with power bi(but first to transform with power query). I would like to expand all table at once time(Every week a new ta...
Let me explain simply :
I have many tables, the first columns of each table is the same and has 43 rows. all the rest change.
So i want to let only the first 43rows and connect everything horizontally (In python it's super easy with the concat command https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.concat.html
where you can choose all excel file and concat horizontally all the sheets. I don't understand why it's so complicated in Power query.
Best regards
Rémy