SPLIT Values into Multiple Columns using FILTERXML

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to split values from single column to multiple columns using FILTERXML Function Kindly watch the video below for more explanation FILTERXML Function The FILTERXML function returns specific data from XML content by using the specified xpath.   Syntax:  =FILTERXML(xml, xpath) xml – eXtensible Markup Language represent […]

Continue reading