Convert Actual and Budget columns from rows into columns

[_Abhilash]

Hello everyone,

 I have below  excel table

Need to convert table into. All the actuals values in one column and budget in one column

Operating Division	Actual	Budget
A	100	90
B	100	99
C	81	86
D	100	93
E	95	83
F	91	99
G	85	92
A	92	97
B	95	84
C	90	92
D	99	87
E	81	94
F	91	99
G	92	94
A	89	86
B	83	100
C	92	95
D	82	89
E	81	84
F	100	100
G	83	82
A	83	100
B	92	82
C	89	97
D	89	82
E	82	91
F	87	82
G	91	100

[TheoC]

Hi @_Abhilash 

If you go into Power Query, you can achieve this by selecting all of the columns (except for Operating Division), and then right clicking and pressing "Unpivot Columns". Here is a link as well to further explain: https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...

I just realised with your data it's a little different as you also have each month in the column header. I've cleaned your data up and added a PBIX to the attached to get the output looking like this:

Hope this helps!

Theo

[jaipal]

@_Abhilash go to Power Query, select Actual columns  and select Unpivot Columns

Do it for Budget Columns as well, and Rename Attribute, Values 

[TheoC · Accepted solution]

Hi @_Abhilash 

If you go into Power Query, you can achieve this by selecting all of the columns (except for Operating Division), and then right clicking and pressing "Unpivot Columns". Here is a link as well to further explain: https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f5882...

I just realised with your data it's a little different as you also have each month in the column header. I've cleaned your data up and added a PBIX to the attached to get the output looking like this:

Hope this helps!

Theo