G
gimme_this_gimme_that
Suppose Sheet1 looks like this:
KEY|VALUE
100 | Chevy
200 | Honda
Suppose Sheet2 looks like this:
KEY|VALUE
100 | Corvair
100 | Corvette
100 | Impala
200 | Accord
200 | Civic
How do I create Sheet3?
100|Chevy|Corvair
100|Chevy|Corvette
100|Chevy|Impala
200|Honda|Accord
200|Honda|Civic
Thanks.
KEY|VALUE
100 | Chevy
200 | Honda
Suppose Sheet2 looks like this:
KEY|VALUE
100 | Corvair
100 | Corvette
100 | Impala
200 | Accord
200 | Civic
How do I create Sheet3?
100|Chevy|Corvair
100|Chevy|Corvette
100|Chevy|Impala
200|Honda|Accord
200|Honda|Civic
Thanks.