I would like to tag my pivoted columns with a common name.

For example if this is my table.

I would like to pivot it as below. By adding State as a tag to the column name created.

Thank

Sreelatha