Thanks for your response. I did try using 'Custom Split' but its only returning split columns but not rows.
For my use case - I ended up redesigning my source excel file as separate tabs and wrote a custom sql in my tableau connection. May be not an optimal design but it works.
I should think there still could be a way.
My apologies, I wasn't clear on what your desired output should look like.
If you wouldn't mind, please post how would you like to see you example lines separated.