I have an excel file of approx 1 million rows. There are only three columns with the items differentiated by item numbers. I need to somehow flip this data from so that I only have one row per item number with a separated columns per PO Text. Below are two item numbers and their associated info. Below that are the results that I need to get for the entire file. Essentially I need one row for each item, extract the info in the PO Text with the first row to be the noun, modifier, and the rest of the information broken into labels. I need the info separated by : into the label values, I do not need to keep the 'Type', ' electrical rating', etc, just the values for that label. I also need everything in the FABRICANTE (MANUFACTURER): fields broken into the Manufacturer, and the part number, again separated by the :
If this is too difficult then essentially what I need only need the item number, short description and the FABRICANTE (MANUFACTURER): information broken out. I don't need all of the label info if that is too difficult?
Is this possible or is there another way I can display this information to show what I need?