Log file extraction
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.
|