Forum Discussion
Power Query, Transform
In attached file a custom M function named TableSplitColumns that takes 2 arguments:
- The Table tat contains column(s) to split
- The Delimiter to split the columns
The function does:
#1 Takes the 1st record of the Table to...
#2 identify the fields/columns that contain the specified Delimiter
#3 With https://learn.microsoft.com/en-us/powerquery-m/list-accumulate splits each column identified at #2
LorenzoCan you please share all the steps you followed for this.. I attach a sample excel with columns all needing the same delimiter ":" , so from here once you load it into Power Query , then what Steps to be followed?
Many Thanks ,
Br,
Anupam
Why do I see a double-header when I open your file?:
Can row #2 be deleted before anything else? If not please explain