Today, we have got another excel challenge where we need to get all these values from non continuous into a column. Try your formula and post it in comment box.
Leave a Reply
Want to join the discussion?Feel free to contribute!
Today, we have got another excel challenge where we need to get all these values from non continuous into a column. Try your formula and post it in comment box.
Here is the solution
‘=FILTERXML(“”&SUBSTITUTE(TEXTJOIN(“|”,TRUE,d),”|”,””) &””,”//Root/Data”)
It’s not working can you please share the excel sheet with formula
this will work if you have TEXTJOIN and FILTERXML formula in your excel version.
Please share solution,