I have imported a log file into Excel as a csv file, the log file is 6 column wide, and 5 rows deep before it repeats

In column A the format is like this

The first row is text (and is in line with the text in the other five columns)
The second row is blank


The third row is text (and a row I want to keep)
The fourth row is text
The fifth row is text (and a row I want to keep)

All other columns are a single row

See the attached layout sheet I have uploaded showing the layout, the rows\columns I want to keep are coloured green.

Can anybody advise how best to do this please.

Attached Files

forum post.xlsx (9.4 KB, 10 views)