How to use this template

Just paste your raw data in the first sheet:

Result will be generated automatically in the second sheet: