Aline data horizontally in excel using vba or vbs [Closed]

akashneelh 12 Posts Wednesday September 19, 2012Registration date January 5, 2013 Last seen - Jan 5, 2013 at 07:12 AM - Latest reply: Ambucias 52606 Posts Monday February 1, 2010Registration dateModeratorStatus June 22, 2018 Last seen
- Jan 5, 2013 at 07:19 AM
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
See more 

1 reply

Ambucias 52606 Posts Monday February 1, 2010Registration dateModeratorStatus June 22, 2018 Last seen - Jan 5, 2013 at 07:19 AM
0
Thank you
Greetings,

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

http://ccm.net/contents/ccmguide/ccmcharte-respect-autrui.php3#politesse

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator