Need Excel Macro for CSV eCommerce Load Sheet

I am receiving load sheets in CSV format (Drupal format) and need to convert them to Shopify format. The main issue are images. For Drupal, the images are in one cell delimited by a vertical line | , but for Shopify multiple images for one product requires a separate line with the product ID and second image link. It is very time consuming to manually convert the files so I would like to have a macro or other conversion tool created to convert these CSV files. Example of the CSV I receive (1.58mb file) and example of a small sample of corrected CSV is attached.