macro to align input data

[maheshr68]

Greetings!! Experts

hav 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.

Need output as below--


1) IP Address Country Region City Latitude/Longitude ZIP Code Time Zone Net Speed ISP Domain IDD Code Area Code Weather Station

137.101.228.252 UNITED KINGDOM - - 54.15 -4.473 - +00:00 DSL AKHTER GROUP PLC NETSOLIR.COM 44 - UKXX0233 - ESKMEALS

2) IP Address Country Region City Latitude/Longitude ZIP Code Time Zone Net Speed ISP Domain IDD Code Area Code Weather Station

77.101.232.214 UNITED KINGDOM ENGLAND LONDON 51.517 -0.105 - +00:00 DSL BROADBANDAUDIT VIRGINMEDIA.COM 44 - UKXX0085 - LONDON


Best Regards
Mahesh

 

[maheshr68]

Output required as below--

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	IP Address	Country	Region	City	Latitude/Longitude	ZIP Code	Time Zone	Net Speed	ISP	Domain	IDD Code	Area Code	Weather Station
2	137.101.228.252	UNITED KINGDOM	-	-	54.15 -4.473	-	+00:00	DSL	AKHTER GROUP PLC	NETSOLIR.COM	44	-	UKXX0233 - ESKMEALS
3	77.101.232.214	UNITED KINGDOM	ENGLAND	LONDON	51.517 -0.105	-	+00:00	DSL	BROADBANDAUDIT	VIRGINMEDIA.COM	44	-	UKXX0085 - LONDON
Sheet1