#1
|
|||
|
|||
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. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Copy and Paste from File to File but File Names always change | aaronbauer1980 | Excel Programming | 1 | 04-15-2016 05:53 PM |
Data extraction from a cell! | JTevez | Excel | 2 | 10-14-2015 11:56 PM |
Bibliography creation and automatic extraction | styxsailor | Word | 3 | 11-30-2012 02:42 PM |
excel cannot open the file .xlsx because the file format or file extension is not val | teddysika | Excel | 1 | 11-22-2012 06:06 AM |
Email Extraction | dpad | Outlook | 1 | 08-17-2010 06:01 PM |