In this video tutorial, I show us how to split data into multiple columns using the FILTERXML Function in two examples. This is the part 1 of achieving the split. In part, I will show us another formula-based operation to split the same data. If you enjoy this video, give likes and comment.. Remember to subscribe and hit the bell icon to be notified of new video