maheshr68
07-29-2010, 08:06 AM
Greetings!!
have input data as below--
1) IP Address Country Region City Latitude/
Longitude ZIP Code Time Zone
137.101.228.252 UNITED KINGDOM - - 54.15
-4.473 - +00:00
Net Speed ISP Domain
DSL AKHTER GROUP PLC NETSOLIR.COM
IDD Code Area Code Weather Station
44 - UKXX0233 - ESKMEALS
2) IP Address Country Region City Latitude/
Longitude ZIP Code Time Zone
77.101.232.214 UNITED KINGDOM ENGLAND LONDON 51.517
-0.105 - +00:00
Net Speed ISP Domain
DSL BROADBANDAUDIT VIRGINMEDIA.COM
IDD Code Area Code Weather Station
44 - UKXX0085 - LONDON
Want to arrange this data into excel fields named accordingly and in a single line. Currently it is not possible to even import fields as they are not to be located in the first line.
Please assist me to get output as in the attached excel file
Best Regards
Mahesh
have input data as below--
1) IP Address Country Region City Latitude/
Longitude ZIP Code Time Zone
137.101.228.252 UNITED KINGDOM - - 54.15
-4.473 - +00:00
Net Speed ISP Domain
DSL AKHTER GROUP PLC NETSOLIR.COM
IDD Code Area Code Weather Station
44 - UKXX0233 - ESKMEALS
2) IP Address Country Region City Latitude/
Longitude ZIP Code Time Zone
77.101.232.214 UNITED KINGDOM ENGLAND LONDON 51.517
-0.105 - +00:00
Net Speed ISP Domain
DSL BROADBANDAUDIT VIRGINMEDIA.COM
IDD Code Area Code Weather Station
44 - UKXX0085 - LONDON
Want to arrange this data into excel fields named accordingly and in a single line. Currently it is not possible to even import fields as they are not to be located in the first line.
Please assist me to get output as in the attached excel file
Best Regards
Mahesh