Mar 28 2022 10:26 AM
Looking to move all rows with like ID (Column A) to the same row so only one row per ID.
Mar 28 2022 11:38 AM
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.
Mar 28 2022 11:40 AM
@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.
Mar 28 2022 11:51 AM
Power Query could do the job if you consider such option. Group table on ID and Text.Combine accounts on aggregation.
Mar 28 2022 12:12 PM
Mar 28 2022 12:34 PM - edited Mar 28 2022 12:37 PM
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.
Mar 28 2022 12:41 PM
@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: