Text to rows

[Lakshmi Narain]

Dear All,

PFA of the data and help me with the Text to rows

 

[Somendra Misra]

Hi Lakshmi,

See the file, yellow cells are helper cells.

Regards,

 

[Lakshmi Narain]

Hi Lakshmi,

See the file, yellow cells are helper cells.

Regards,

Thank you somendra, You are rocking with Index Indirect match offset and more functions. I am still confused How Index Indirect match offset functions are working.

 

[Somendra Misra]

Glad you solved it. If you have problem in the logic, write back, I will try to clear it.

Regards,