Help with Moving Rows to columns

Copper Contributor

Looking to move all rows with like ID (Column A) to the same row so only one row per ID.

Screenshot 2022-03-28 132309.jpg

6 Replies

@cheeney 

Copy Sheet first to prevent data loss.
With the copied sheet, select entire table range and then
go to Data> Remove Duplicates
Only tick A column (ID) and then press ok.
That's it.

Starrysky1988_0-1648492657314.png

 

@Starrysky1988  Sorry maybe I did not explain correctly.  I need to move the data in any matching row ID so they are all in one row.

 

So row two would  move up to row one but retain all data from both rows.  

@cheeney 

Power Query could do the job if you consider such option. Group table on ID and Text.Combine accounts on aggregation.

Thank you for the reply. I guess I am not Excel savvy enough to do this. Any services/individuals out there to pay to do this for me?

What you want is only 1 row with line feeds in between the same ID, right? Whether there have got 1 line or more than 1 lines of data for each ID, the result must be only in 1 Row and it will be something like below.
A1| ID Customer .......
A2|  1  ?????@
           ?????@
A3|  2  ?????1
           ?????2
           ?????3
            ............
Please let me know if it is what you want.

@Starrysky1988 thanks again. What I need if the row ID is the same I need all that data ONLY on one row but I need to keep all that data. Like:

Screenshot 2022-03-28 154058.jpg