Horizontal to Vertical Data Visualization

I want to change the layout of data as per following scenario:-

Current
Region Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Region-A 1 5 6 4 7 8 10 3 6 9 7 10
Region-B 3 6 9 8 10 3 3 6 9 7 6 4


Required
Region Month Sales
Region-A Jan 1
Region-A Feb 5
Region-A Mar 6
Region-A Apr 4
Region-A May 7
Region-A Jun 8
Region-A Jul 10
Region-A Aug 3
Region-A Sep 6
Region-A Oct 9
Region-A Nov 7
Region-A Dec 10
Region-B Jan 3
Region-B Feb 6
Region-B Mar 9
Region-B Apr 8
Region-B May 10
Region-B Jun 3
Region-B Jul 3
Region-B Aug 6
Region-B Sep 9
Region-B Oct 7
Region-B Nov 6
Region-B Dec 4

Hello and welcome to the forum.

I would use Power Query for this.

1) Highlight A1:M3 > Data > From Table > OK
2) Transform > With the Region column selected, Unipvot Columns > Unpivot Other Columns
3) Rename Columns
4) Home > Close & Load

See attachment.

Doesn't have Power Pivot in my Excel 2013.

Any other alternatives?

Not power pivot, power query.

You can download it as an add-in for free directly from the Microsoft site.

Ali, I believe Get & Transform was not included until 2016.

Unless I am mistaken, PQ has to be downloaded for 2010 and 2013.

If you want to use formulas for this, with your data in A1:M3, you can use these:

O2 =INDEX(A:A,INT((ROWS($1:1)-1)/12+2))

P2 =INDEX($1:$1,MOD(ROWS($1:1)-1,12)+2)

Q2 =INDEX($B$2:$M$3,MATCH(O2,A$2:A$3,0),MATCH(P2,B$1:M$1,0))

See attachment.

I have Power Query now.

Please help solving this through Power Query.

Thanks in advance.

Great....it's done.

Thanks 63falcondude & AliGW & ofcourse Excel Forum :-)

You're welcome. Glad we could help.