Hi Brian,

If all titles are the same you could reach your first option based on a union

If all titles must be maintained "as is" you could reach your second option based on a union.

A union in Tableau is explained here

Brian,

You can pivot both tables only if you can join them by common key. If it is not a big deal, can you add a common key to both tables then join them on that key and then pivot both tables and then you can get what you want.

Brian,

I agree with Norbert that a union is going to give you what you need.  You may initially end up with a table that has all the rows of Table 1 and Table 2 instead of aggregated rows of Table 1 with rows of Table 2.  But this should be fine because you can use aggregation in the Tableau viz to sum together all the 1 values to get the quantity.

You might find a calculation like this

[Quantity]

ZN(Sale) + ZN(QTY)

helpful to combine the Sale and QTY fields.  Then treating that as a measure (specifically a SUM) in your view will give you correct results.

Hope that helps!

Joshua