Input:
Desired Result:
I am trying to format an excel file so that it removes the “Item”, which is erroneously listed as the first row in the “Description” column, and then combine the remaining multi-row descriptions into a single cell for each unique entry.
What might be the best way to accomplish this?