Is it possible to create a pivot table from 2 different tables when each table has different columns? They both have 4 columns that are identical but table A has 7 columns of data and table B has 6.
Both tables have store #, date, market, & franchisee but Table A has item number, sales, cost and Table B has traffic and pricing tier.
Both tables have store #, date, market, & franchisee but Table A has item number, sales, cost and Table B has traffic and pricing tier.
Last edited:
