How to query XML data with repeating rows in Excel

Hey there, I am capturing XML data from Nintex into a SharePoint list that I am then exporting to an Excel spreadsheet. Below I've captured an example of what the XML data looks like in a cell in th...

excel

Formulas and Functions

Harun24HR
Aug 02, 2022
xeno85
You can wrap your FILTERXML() formula by TEXTJOIN() to capture multiple values to a single cell.
=TEXTJOIN(",",TRUE,FILTERXML(D2,"//Item/_3cc4ee36ff3e3c3127264282cdae23e4"))

Harun24HR

Bronze Contributor

Aug 02, 2022

xeno85

You can wrap your FILTERXML() formula by TEXTJOIN() to capture multiple values to a single cell.

=TEXTJOIN(",",TRUE,FILTERXML(D2,"//Item/_3cc4ee36ff3e3c3127264282cdae23e4"))

xeno85
Copper Contributor
Aug 02, 2022
Hey Harun,
You are a legend!! Thank you so much!! I didn't even consider this option. You've just made someone immensely happy! Appreciate the prompt response mate.

Forum Discussion

How to query XML data with repeating rows in Excel

Resources