Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
70
Views
Topic starter
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!
Casey
Posted : 08/01/2022 10:37 am
Hi Casey,
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.
Mynda
Posted : 09/01/2022 8:15 pm
