Change month columns into multiple rows and columns

[canddig]

Hi, 

I am trying to figure out how to take month columns and make them rows but keep the month they belong to as a value in the row. I need to keep the columns that they are but have the rows notate the month they belong to. Here is an example of my data and the out put I am trying to achieve. 

Thanks, 

Candace 

Current Format

Expected Output 

[binuacs]

@canddig can you provide the sample data in excel?

[canddig]

Yes! 

[binuacs]

@canddig 

[Tiffyyy]

@canddig , another solution for your consideration.

[danilang · Accepted solution]

Hi @canddig 

Similar to @binuacs', but without requiring the month translation table

  Dan

[canddig]

Thank you all so much. I was able to move this from sample data into production and it works great. I appreciate your time and efforts on this, I literally couldn't have done it without you.