In a report that exports from our tax software I am trying to set up a workflow. The way the report exports might have the same code in multiple sections. So, each one is unique, but only to the extent the code is combined with the section. The report also puts the code in the same cell as the description, separated by a colon. I have used the text to column function to break out the code from the description. When I do this, I can identify the "section" by a null in the field with the descriptions. I am trying to find a way to combine the field where I isolated the code but I want to merge this into a new field with the "section" to make it unique. In the exported file attached, I am trying to achieve something like what I did in column E in Excel.
