Thank you, another way is sort descending custom column then split column and just remove last part of the function. It will create column based on first row.
Thank you, nice video. I would personally have added a few extra steps so the query turns out a proper dataset then set it up as a function that can be invoked whenever new files are added to the portfolio directory.
Hello Dear, Thanks for the nice video. I have a column with multiple line items where I want to split the column into two columns the only criteria is that the split has to happen from the fourth instance of the Space from Right to left. I know it is possible but don't know how to do it.
Thank you, another way is sort descending custom column then split column and just remove last part of the function. It will create column based on first row.
incredible! i didnt know that! thanks for the tip!
Super useful tutorial and I really appreciate the added link for the file used in the video so I can follow along on a practical level 👌🙏👌
Thank you, nice video. I would personally have added a few extra steps so the query turns out a proper dataset then set it up as a function that can be invoked whenever new files are added to the portfolio directory.
yes totally agree functions are the way to go here
Thanks a lot. You saved my day.
tks u
can you sort the stocks before the split so the same stock appears is the same column per row? i.e. null null HIJ in one row and another ABC null HIJ
yes totally!
I need the same thing.
an example of this will help.
What is meaning expression "occurance all"
Subscribed 🎉
glorious than you!
Hello Dear, Thanks for the nice video. I have a column with multiple line items where I want to split the column into two columns the only criteria is that the split has to happen from the fourth instance of the Space from Right to left. I know it is possible but don't know how to do it.