CSV file text to columns

Question

I have attached a small part of a CSV file that I am trying to load.

The challenging part is not only getting the data in a table format, but also each record has 2 rows.

How can I get this data into a table with only one row of data per record?

Sample data from file: (I added where I need the breaks)

TEST CSV.txt

SPetrie · Accepted Answer

Actually, I overthought that. Just split out the first column and roll it up on that since its already paired ids.