Forum Discussion
Getting blank values after the split by column delimiter
Hi Team, i have the following data table . Month parameter Index April TAR LOW,SN HIGH, 5 March ...
You have many options. (remove the last character of parameter column with a formula etc.)
The simplest would be to filter the blank values out (do this from the dropdown at the top of the column) after the split
From what we can see, it seems that your column has been split by rows and each split part was placed into a different row causing duplicates and due to the trailing comma, you are getting a blank row.