Moving Column headers into collective column while attaching to the row/value

[herrmannb34]

I have an excel sheet of data, which has one sheet as a pivot table and one sheet as the data itself. It is a forecast for this upcoming year, with values for each month and department number. Right now, there are department numbers as the row header and the numbers across the sheet underneath the correct month. So, each individual month is a column header and the values beneath it correspond to the month and department number. I am wanting to eliminate all the month columns and have only one column contain the values, but I do not want to combine the values into a total, I want them to have their own separate line. Then, I want the month label to be in a column adjacent to the corresponding value. Is there any easy way to do this? I can do it by copy and pasting the data a lot, but I wanted to see if there was any easy way to this (maybe using a pivot table?)

[cbatrody]

Hi,

Welcome to the Forum.

You would get better help if you attach a sample workbook with enough data to demonstrate your requirement. Make sure your desired results are shown, mock them up manually if necessary. Remember to desensitize the file by removing all confidential information before upload!

See the following URL for help on how to upload a file.
http://www.excelforum.com/members/da...ch-a-file.html