Forum Discussion
Solved
Combining rows of Data into Single ROW
Version: EXCEL 365 for MS I will have to explain the issue without posting the actual excel, as it is corporate information. I have 1000's of rows of 15 columns. The first 12 columns iden...
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.
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.
- Thank you - that gets me moving again!!