Forum Discussion
Combining rows of Data into Single ROW
You may click on
and in the pane double click on query name to open Power Query editor
In the pane of it you may select on steps one by one to check which transformations they perform
If you see all this first time you could have a lot of question, but that's better discuss on the sample which is more close to actual data, at least have same number of colums.
Staring from Excel 2016 it build in, nothing to install. On Excel 365 that everything what is in these sections of ribbon
- I apologize for my ignorance - I have found those items in my excel. I also looked at the example you supplied. The example seems to work, but it does not show the method or actions you performed?
You may click on
and in the pane double click on query name to open Power Query editor
In the pane of it you may select on steps one by one to check which transformations they perform
If you see all this first time you could have a lot of question, but that's better discuss on the sample which is more close to actual data, at least have same number of colums.