1. Create new file in Excel
  2. Select the "Data" tab
  3. Select "From Text/CSV" in the "Get and Transform Data" section from the ribbon

  4. Navigate to the Downloads folder (or the location where your caption file is stored) and select "All files" in the Text files drop down
  5. Open the selected file (file with "cc" extension")

  6. Choose "Tab" in the "Delimiter" drop down menu
  7. Click Load

  8. Once your data is loaded, deselect "Header Row" in the "Table Design" tab>"Table Style Options" ribbon section

  9. Delete the first three rows from the table (one by one) by right clicking on the row number and selecting "Delete"

  10. Select cell B1 and Paste the formula =INDEX($A:$A,ROW(A1)*3-3+COLUMN(A1)) in the formula bar. Press Enter
  11. Select cell C1 and Paste the formula =INDEX($A:$A,ROW(B1)*3-3+COLUMN(B1)) in the formula bar. Press Enter

  12. Select and copy the cleaned data from columns B and C

  13. Paste the "Values" in Sheet1

  14. Rename Sheet1 as desired