Split line breaks into separate rows

[mestevez1]

Hello,

I'd like to split line breaks into separate rows from an Excel file so I can perform calculations. I'd like to transform this:

Into this:

I've attached a sample file for reference. Any help would be greatly appreciated!

Thanks,

@mestevez1 

[Thableaus · Accepted solution]

Hi @mestevez1 

I don't have much time to detail the workflow right now, but I provided you a solution.

Take a look and if you have any questions let me know.

WF attached on version 2018.4

Cheers,

[mestevez1]

Thank you for the awesome solution @Thableaus! That does exactly what I was looking for.

[bb]

Hi @Thableaus is there a way, you can send me this file in older version. I cannot open it in mine since I have 2018.3. Thanks!!

[Thableaus]

Sure @bb 

Here it goes. It's attached.

Cheers,