All,
My original spreadhsheet with user name, location and package is in this format:
<tbody>
</tbody>
I want to format the above spreadsheet so if Col - Package contain either words CBOT or COMEX or NYMEX or CME then i want a new sheet with following information
<tbody>
</tbody>
Thanks in advance for helping in this project
My original spreadhsheet with user name, location and package is in this format:
First | Last | Location | Package | |
Andrew | Wan | Chicago |
<tbody> </tbody> | |
Nicole | Andy | New York |
<tbody> </tbody> | |
Ram | Sinha | Seattle |
<tbody> </tbody> |
<tbody>
</tbody>
I want to format the above spreadsheet so if Col - Package contain either words CBOT or COMEX or NYMEX or CME then i want a new sheet with following information
First | Last | Location | Package |
Andrew | Wan | Chicago | CBOT |
Andrew | Wan | Chicago | COMEX |
Andrew | Wan | Chicago | NYMEX |
Nicole | Andy | New York | CBOT |
Nicole | Andy | New York | CME |
Nicole | Andy | New York | Comex |
Nicole | Andy | New York | NYMEX |
Ram | Sinha | Seattle | CME |
Ram | Sinha | Seattle | NYMEX |
<tbody>
</tbody>
Thanks in advance for helping in this project