Jun 25 2021 12:15 PM
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...
Jun 25 2021 12:36 PM
Jun 25 2021 01:03 PM
Jun 25 2021 01:09 PM
Staring from Excel 2016 it build in, nothing to install. On Excel 365 that everything what is in these sections of ribbon
Jun 25 2021 01:11 PM
Jun 25 2021 01:24 PM
SolutionYou 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.
Jun 25 2021 01:33 PM
Jun 25 2021 01:24 PM
SolutionYou 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.