Converting Month Data in Columns to Rows

[dammwj]

In the book Pivot Table Data Crunching, Mr. Jelen steps through a Case Study "Cleaning Up Data for Pivot Table Analysis". He points out that data presented in columns by month needs to be reformatted as two columns. He states "this step either requires a fair amount of copying and pasting, or a few lines of VBA code".

My question is: What are these few lines of code? I have budget data in an Excel sheet by month, and I would like to reformat this data into rows, with a separate record for each month.

I am sure this question has been asked and answered many times in this forum, but I can't find it. Many thanks for any help on this issue.

WJD

 

[MrExcel]

Can you send me an e-mail with a sample of the data set? (Feel free to replace any real numbers with zero. I am only interested in the structure). I can write the VBA, post it here, and show it on a podcast.

Send to bill at MrExcel.com