This is a unique situation and something I cant seem to figure out. Basically, I’ve got 3 columns: (1) opportunity ID, (2) competitor amounts, (3) competitor names.
There is one opportunity ID per row, but up to several competitor amounts and competitor names all in the same field. I need to extract each competitor and associated competitor amounts (extract by delimiter for both and then you have like 5 new columns for each extraction) and get them in to rows in the appropriate sequence. See image below. I also attached the excel backup. Can someone help?Data Scenario.xlsx (18.2 KB)