Transaction Month Data not Processing in Pivot Table as expected

Google Sheets
,
1

Hi, I create a pivot table from the transaction tab however my monthly data is not populating as expected.
I use this formaul to create the month from transaction, the transaction date filed column is A. =ARRAYFORMULA(IF(ROW(A1:A)-1,DATE(YEAR(OFFSET(A1:A,0,COLUMN($A$1)-1)),MONTH(OFFSET(A1:A,0,COLUMN($A$1)-1)),1),“Month”))

When I create pivot table in google sheets the month is duplicating the month row for new year.
When I copy data into excel and create a pivot table all the months for all years are consolidated as expected. I reformatted the data there is no change.

Any suggestion on how to format the month field so it won’t duplicate as a new row when its a new year.
example:

Month
01-January
02-February
03-March
04-April
05-May
06-June
07-July
08-August
09-September
10-October
11-November
12-December
01-January
02-February
03-March
04-April
05-May
06-June
07-July
08-August
09-September
10-October
11-November
12-December
01-January
02-February
03-March
04-April
05-May

My excel pivot table works as expected,

Category Natural Gas
Column Labels
Row Labels 2012 2013 2014 2015 2016 2017
1-Jan
2-Feb
3-Mar
4-Apr
5-May
6-Jun
7-Jul
8-Aug
9-Sep
10-Oct
11-Nov
12-Dec

Thank you!

2

@m.svoboda09 hi! Am I missing something, or could you just wrap your array formula in a UNIQUE function to remove the duplicate rows? If that won’t work let me know.

Also, just FYI, it helps to use the “preformatted text” formatting (see image below) whenever you’re including code in a post here. I learned the hard way that sometimes the formatting does weird things when you try to copy the code back into a spreadsheet.
image

3

Hello,
Thank you for your response and suggestion. I will look at updating the code and let you know the results.
Kind regards,
Michael