Hi team,
I have a data like below:
Category | Region | Manager M1 Actual | Manager M1 Budget | Manager M2 Actual | Manager M2 Budget | Manager M3 Actual | Manager M4 Budget |
Item 1 | East | 437 | 392 | 231 | 352 | 110 | 109 |
Item 2 | East | 452 | 48 | 198 | 238 | 193 | 149 |
Item 3 | East | 229 | 22 | 225 | 35 | 242 | 394 |
Item 4 | East | 93 | 249 | 295 | 60 | 305 | 86 |
Item 5 | East | 224 | 28 | 142 | 162 | 415 | 337 |
And I want to merge the manager name as shown in image attached:
Manager names got changed based on Region.
Is there any way I can achieve this.
Attached is the excel.
Thanks
@Paridhi_Agrawal
Alteryx is good at Data processing, not for visulization 😂
I dont like this approach but hope it will be "look" like what you need.