Aline data horizontally in excel using vba or vbs [Closed]
akashneelh12
Posts Wednesday September 19, 2012Registration date
January 5, 2013
Last seen
-
Jan 5, 2013 at 07:12 AM - Latest reply: Ambucias52606
Posts Monday February 1, 2010Registration dateModeratorStatus
June 22, 2018
Last seen
- Jan 5, 2013 at 07:19 AM
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
Please, bare in mind that Kioskea is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.
Therefore, it is specifically requested from Kioskea forum users to correspond showing mutual respect. Therefore, when requesting assistance, to be courteous and to use polite expressions, as for elsewhere in similar circumstances. (i.e.please, thank you, appreciate, grateful, etc.)
