Help with Moving Rows to columns

Question

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

cheeney · Answer

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?

starrysky1988 · Answer

cheeney&nbsp;Copy Sheet first to prevent data loss.With the copied sheet, select entire table range and thengo to Data&gt; Remove DuplicatesOnly tick A column (ID) and then press ok.That's it.&nbsp;

cheeney · Answer

Starrysky1988&nbsp; Sorry maybe I did not explain correctly.&nbsp; I need to move the data in any matching row ID so they are all in one row.&nbsp;So row two would&nbsp; move up to row one but retain all data from both rows.&nbsp;&nbsp;

sergeibaklan · Answer

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

starrysky1988 · Answer

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|&nbsp; 1&nbsp; ?????@&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;?????@A3|&nbsp; 2&nbsp; ?????1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;?????2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;?????3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ............Please let me know if it is what you want.

Forum Discussion

Help with Moving Rows to columns

6 Replies

Resources