hello,
I ve a spreadsheet in following format and looking to merge columns and make it to single.
Current:
<tbody>
</tbody>
Desire Output
if cbot or cme or nymex or comex has '1' then i want data in following format:
<tbody>
</tbody>
Thanks in advance for your help
I ve a spreadsheet in following format and looking to merge columns and make it to single.
Current:
User | Location | Vendor | CBOT | CME | NYMEX | COMEX |
Brian Hoyer | New York | CQG | 1 | 1 | ||
Sydney Chen | Los Angeles | CQG | 1 | 1 | 1 | |
Ram Nivas | Dallas | CQG | 1 |
<tbody>
</tbody>
Desire Output
if cbot or cme or nymex or comex has '1' then i want data in following format:
User | Location | Exchange | Vendor |
Brian Hoyer | New York | CBOT | CQG |
Brian Hoyer | New York | NYMEX | CQG |
Sydney Chen | Los Angeles | CME | CQG |
Sydney Chen | Los Angeles | NYMEX | CQG |
Sydney Chen | Los Angeles | COMEX | CQG |
Ramn Nivas | Dallas | CBOT | CQG |
<tbody>
</tbody>
Thanks in advance for your help