title: How to use a VBA to combine rows that are prematurely broken from a CSV?
body: <p>I have a CSV showing purchase information, but in each line the data must have too many commas as a few extra breaks are added in. In this case, row 1 is the header. Rows 2-5 should be merged into one, and the blank row 6 shouldn't exist.
  Here's what the data looks like in the "Get Data" feature in Excel before being input</p>
  
  <p><a href="https://i.stack.imgur.com/TAIHD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TAIHD.png" alt="enter image description here"></a></p>
  
  <p>I think the solution provided here is close to what I need to do, but as someone who's never written a Macro I was wondering if someone can provide a more specific solution.
  <a href="https://superuser.com/questions/395126/how-to-combine-values-from-multiple-rows-into-a-single-row-in-excel">https://superuser.com/questions/395126/how-to-combine-values-from-multiple-rows-into-a-single-row-in-excel</a></p>