Zend certified PHP/Magento developer

Combine and Cleanse Multi Row Description in Excel

Input:

Input

Desired Result:

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?