Subscribe Bookmark RSS Feed

removing the merged cells in the XL

fr2007

Community Trekker

Joined:

Jul 3, 2012


iam trying to import excel (.xlsx) file to JMP and I want to customize the format of the XL sheet. THe XL sheet has headings (all cells merged) for every 3 or 5 rows(this is not constant every time). I want to delete the heading and add that in a separate column.

for exam ple , my excel sheet looks like this:-

                                                                 CARS

FORD     CIVIC     BMW     MURANO     COROLLA     ELEMENT     HONDA     NANO   

FORD    CIVIC     BMW     MURANO     COROLLA     ELEMENT     HONDA     NANO    
                                                            FLOWERS

ROSE     TULIP     HIBISCUS     ALLIUM     SUNFLOWER      STOCK     PROTEIA   

ROSE     TULIP     HIBISCUS     ALLIUM     SUNFLOWER      STOCK     PROTEIA    

In the above , each of the "cell" represents a separate "ROW" and "CARS" and FLOWERS are the merged rows..i want to remove the merged rows

I want my outupt to be:-

CARS     FORD     CIVIC     BMW     MURANO     COROLLA     ELEMENT     HONDA     NANO   

CARS     FORD     CIVIC     BMW     MURANO     COROLLA     ELEMENT     HONDA     NANO   

FLOWERS      ROSE     TULIP     HIBISCUS     ALLIUM     SUNFLOWER      STOCK     PROTEIA   

FLOWERS     ROSE     TULIP     HIBISCUS     ALLIUM     SUNFLOWER      STOCK     PROTEIA   

My output should look like the above..