August 20, 2020
Hi - we are trying to up a report from our contracts system.
It generates a Custom Fields column which contains all custom fields used in following text string:
Custom field header 1=Custom field text string; Custom field header 2=Custom field text string 2;
We would like to split all the unique fields out into separate columns and then populate or 'null'.
Great resource - hope you can help!
July 16, 2010
I'm guessing you can use Split by Delimiter once into columns for the separate columns and then into rows for the data. Then you can remove the duplicate headers? Hard to say without a sample file showing your data before and after so we know exactly what you want.