Help with normalizing data

I need help with normalizing my data or is this as normal as it gets. This table is 1 of many, some tables don't have the year column but all have an ID column and Monthly columns. I have to reference these tables in my macros and it seems to take a while to complete. I also would like to use data as pivot which may omit the quarter and total columns. I think this should be fairly simple but my brain has had a complete meltdown. Maybe I'm thinking way outside the box.
Thank you in advance for your assistance.

I do not understand what you are asking or what problem you are trying to solve. Please respond with a specific request.

Thank you for your response. I'm sorry, I didn't ask question correctly. What I need is to know a way (VBA) to convert data to the normal. I have so many of these tables set my initial attachment.

I'm attaching a workbook with example. Normal tab is what I want. The goal is to be able to easily use in a pivot table. I found some code that will almost do what I want, but it includes the year column (Not Normal) in the period column (Normal) and the year (Not Normal) in the amount column Normal). I guess what I need is for the code to skip the 2 column but not sure how to do it. Again, thank you for your help.
Christie

OMG, perfect. Alan....You are the bomb! thanks