Forum Discussion
Help with Moving Rows to columns
Looking to move all rows with like ID (Column A) to the same row so only one row per ID.
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.
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?