Hello,

I am trying to change the orientation of my data, but do not know an efficient way of going about it. I have data for the prices for a basket of different goods across 10 years and multiple states. The data is currently formatted as pictured below. I want to change it so there is a month variable and each of the price series is its own variable.

In other words, I would like my data to look like this

Year Month Price_Series1 Price_Series2 ........

What is the best way to go about this?


Thank you!

Christy