Aline data horizontally in excel using vba or vbs

[Closed]
Report
Posts
12
Registration date
Wednesday September 19, 2012
Status
Member
Last seen
January 5, 2013
-
Hello,



I need to aline these data in to rows .I need to aline it in a excel as i have a huge data of 40000 details in a excel.

Original data...

SUBSCRIBER DETAILS
IMSI MSISDN STATE
405845001382775 919085919027 IDLE

DATE TIME CELLID
130103 122725 404-29-12906-15353

IMEI
356395024630200

SUBSCRIBER DETAILS
IMSI MSISDN STATE
405845002463183 919085325090 IDET

DATE TIME CELLID
130103 103447 404-29-12107-23993

IMEI
354917031429730



Required output:-

IMSI MSISDN STATE DATE TIME CELLID DATE TIME CELLID IMEI
405845001382775 919085919027 IDLE 130103 122725 404-29-12906-15353 356395024630200
IMSI MSISDN STATE DATE TIME CELLID DATE TIME CELLID IMEI
405845002463183 919085325090 IDET 130103 103447 404-29-12107-23993 354917031429730