VBA to expand or transpose large data set

**sledge** · 12-21-2016, 02:53 PM

Hi there,

I have a large data set with many columns for an annual forecast for my company. Here's a rough example of the data structure and what I need VBA to convert it into. I will likely need to use excel since my database pushes the limits of google sheets. The reason for the initial structure is to aid data entry...it's just not conducive to analysis.

Screen Shot 2016-12-21 at 10.51.19 AM.png

Any help would be great!

Michael

**sledge** · 12-21-2016, 02:57 PM

Sorry for the additional attachments, they should be ignored. Couldn't figure out how to remove them.

**Pete_UK** · 12-21-2016, 07:47 PM

It would help if you attached a sample Excel workbook, rather than a picture of one.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete

**sledge** · 12-26-2016, 10:09 AM

Thanks Pete. I've attached the excel file.

Cheers,

Michael

**sledge** · 12-29-2016, 06:50 PM

Can anyone help??? maybe I posted this in the wrong area.

**mike7952** · 12-29-2016, 07:03 PM

Is your example workbook showing the exact data format/structure/layout of your live workbook? With the months grow or will there always be only 3 months? Will there always be only Price Volume and Revenue?