How can I rename a column name while creating Pivot table.

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

For example if this is my table.

TypeStateValue
SoilAR1
TreesAR2
PlantsAR3
RocksAR4
SoilIL6
TreesIL7
PlantsIL7
RocksIL8


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

TypeState_ARSate_IL
Plants37
Rocks48
Soil16
Trees27

Thank

Sreelatha