automation of data format conversion to parent child format

Posted by silverkid on Stack Overflow See other posts from Stack Overflow or by silverkid
Published on 2010-03-06T01:04:20Z Indexed on 2010/03/08 5:51 UTC
Read the original article Hit count: 786

Filed under:
|
|
|

This is an excel sheet which has only a single column filled for each row. (explanation : all CITY categories fall under V21 , all handset categories fall under CityJ and so on )

   V21                  
       CITYR
       CITYJ
           HandsetS
           HandsetHW
           HandsetHA
               LOWER_AGE<=20
               LOWER_AGE>20     
                   SMS_COUNT<=0 
                       RECHARGE_MRP<=122
                       RECHARGE_MRP>122
                   SMS_COUNT>0

I need to change this format to a double column format with parent and child category format. therefore the output sheet would be

    V21           CITYR
    V21           CITYJ
    CITYJ         HandsetS
    CITYJ         HandsetHW
    CITYJ         HandsetHA
    HandsetHA     LOWER_AGE<=20
    HandsetHA     LOWER_AGE>20      
    LOWER_AGE>20    SMS_COUNT<=0    
    SMS_COUNT<=0    RECHARGE_MRP<=122
    SMS_COUNT<=0    RECHARGE_MRP>122
    LOWER_AGE>20    SMS_COUNT>0

the datas are huge so i cant do them manually . how can i automate this ?

© Stack Overflow or respective owner

Related posts about excel

Related posts about vbscript