How to stop Repeating Rows

[bb84ss454]

I'm working with a Fuel injection controller. It generates a .csv file for the output of all the different sensors.
The problem is that there are labels in the top row (not the issue) that repeat every other row.(this is the problem)
What it should do is spread the labels across the top row and then all the data falls into columns below the labels.
What I'm getting is a mess. I have to go in and delete every other row just to look at it.

 

[Fluff]

If you just want to delete those rows, try

Sub bb84ss()
   Range("A2:A" & Rows.Count).SpecialCells(xlConstants,xlTextValues).EntireRow.Delete
End Sub

 

[bb84ss454]

I contacted the company and they said it was a setting in Excel, that I needed to set it up for columns. I'm lost.

 

[Fluff]

If you open the csv in notepad, do you still see the extra headers?

 

[bb84ss454]

Yes, it does the same thing.

 

[Fluff]

In that case it's to do with the way the csv is created & nothing to do with Excel.