Find values from text

In this example we find list of products including all parameters on same cell. There's also missing standard, so each row can be totally different. Yet, we have to find from each line parameters like CPU type, Screen Size, etc.


The first sheet (Step 1) contains raw input data including purchase prices from different vendors.


Customer needed to know difference between average purchase price vs cheapest purchase price per SKU


We started off by removing duplicates in PID, Description and Vendor name.