if i have a pivot table

how can i search multiple values by the label so that i can populate a new
spreadsheet

ex

you will notice in my 2 tables below that in my pivot table i don't have a
column b
but on my new table I do. How would i do this with code?

pivot table
a c d
a 1
b 2
c 3



new table

a b c d
a 1
b 2
c 3