Results 1 to 2 of 2

Macro for Conditional Transpose

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2011
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Macro for Conditional Transpose

    Dear Team,

    I need a Macro which can Transpose a number of rows into columns based on a condition-

    Input Format-
    6/20/2011 8:34
    CELL 1 CDM 1
    NO CRC HEARTBEAT
    6/21/2011 21:07
    CELL 1 CDM 1
    SIGNALING LINK UP
    SIGNALING LINK UP but No calls
    INIT:CELL 2:SC!
    OK
    6/21/2011 21:07
    CELL 1 CDM 1
    NO CRC HEARTBEAT

    Output Format
    6/20/2011 8:34 CELL 1 CDM 1 NO CRC HEARTBEAT
    6/21/2011 21:07 CELL 1 CDM 1 SIGNALING LINK UP SIGNALING LINK UP but No calls INIT:CELL 2:SC! OK
    6/21/2011 21:07 CELL 1 CDM 1 NO CRC HEARTBEAT

    Find the attachment for better understandin of the problem and the kind of output I want.

    -Kundan Debnath
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1