Pivot Table and Grouping on 2 Date Columns at Parallel Level

Romi Kishore

New Member
Joined
Jul 29, 2011
Messages
5
Consider the data as follows.

Region Date1 Number1 Date2 Number2
RegionA Feb-2011 2 Apr-2011 3
RegionA Feb-2011 1 Apr-2011 2
RegionA Mar-2011 1 May-2011 2
RegionA May-2011 1 Jul-2011 2
RegionA May-2011 1 Jul-2011 2
RegionA May-2011 1 Jul-2011 2
RegionA May-2011 2 Jul-2011 3
RegionB May-2011 1 Jul-2011 2
RegionB May-2011 1 Jul-2011 2
RegionB May-2011 1 Jul-2011 2
RegionC May-2011 2 Jul-2011 3
RegionC May-2011 2 Jul-2011 3
RegionC Feb-2011 5 Apr-2011 6
RegionC Aug-2011 5 Oct-2011 6

I want to group the data based on Date1 and Date2 columns (grouped as Months) on columns and Regions in Rows, whereas the numbers should be summed up. But the key part of the puzzle is that Date1 and Date2 columns should be one (at parallel level) after the other and NOT one under the other. Can this be done in Excel? And of course, the Number1 should be linked with Date1 and Number2 with Date2.
 
Last edited:

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Forum statistics

Threads
1,224,583
Messages
6,179,681
Members
452,937
Latest member
Bhg1984

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top