I have a spreadsheet with multiple rows with data, each has a common cell (say ID#). I wish to roll up each row to make it one row within the ID#. No column will overlay anything from another row.
example
ID# A B C
111 xxx xxx
111 xxx
I want it to look like this:
ID# A B c
111 xxx xxx xxx
Can I do this with basic EXCEL?
Bookmarks