I want to build a pivot table based on data in 2 tabs.

The layout of the two tabs a

CC Company Std Inv Concant
23 1 12 10 23-1

I want the pivot to look like:

Concant Std Inv
23-1 12 10

I'm picking the mulptiple consolidation ranges, but then it's not letting me
set the format like in a single range. Can I not do that? I'm using sumifs
to get around using a pivot, but I think a pivot would be much cleaner.

thx.