Large Data Pool Import & Transpose
Posted on 2010-04-07
Hey all, simple question I'd assume..
I have a notepad file, currently saved as a .log file. I need to import it into Excel. Easy enough, with the import external data feature. My issue arises due to the fact I need to transpose this data, which is easy to do, but I have 255 entries I need transpose. Is there an option / way to specify the transpose when importing the data in excel?
Currently, the data looks like this;
Host Name: No DNS Entry
IP Address: 192.168.1.1
Ping Response: ip dest host unreachable
I need the entire field of 255 IP's transposed across. I can create the horizontal Host Name, IP Address, etc title blocks, but how do I go about transposing the actual data I've gotten off my network scan, without doing it 255 times?