Forum Discussion
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 identify the individual and the last 3 columns identify certain confidential information. Individuals may appear up to 10 times in the dataset and the information is always the same for that individual in the first 12 columns; however, the last 3 columns will be different each time.
I need to create 1 row for each individual that contains the data from columns 1-12 and then add the information from the last three columns to that row each time the individual appears. The data cannot be combined into a single cell. Therefore a person appearing 1x in the list will have 15 columns of information, a person appearing 2x will have 18, 3x will have 21, etc etc. I can sort or manipulate the data by any column to facilitate...
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.
6 Replies
- I am not familiar with Power Query. I see that it is an add-on for excel. Once I download, how would I set it up to make the manipulations I need?
Staring from Excel 2016 it build in, nothing to install. On Excel 365 that everything what is in these sections of ribbon
