Report

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

Ask a question akashneelh 12Posts Wednesday September 19, 2012Registration date January 5, 2013 Last seen - Last answered on Jan 5, 2013 at 07:19 AM by Ambucias
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
Helpful
+0
plus moins
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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!