Text to row Query

[PraveenX]

I have a data (given in the "Input tab" of query) , I would like data as disclosed in the "Output tab".

[phottovy]

@PraveenXThis is a tricky setup but here is what I put together. It wouldn't work well if the source changed though.