Forum Discussion
sdaha20
Microsoft
MicrosoftUNABLE TO PIVOT SUBTASKS: HOW TO TRANSPOSE SUBTASKS FROM COLUMNS TO ROWS
Hello Everyone,
|
Product |
22-May |
22-Jun |
22-Jul |
22-Aug |
|
Online NA |
|
|
|
|
|
Supply |
10 |
5 |
|
5 |
|
Demand |
10 |
5 |
0 |
|
|
Balance |
10 |
5 |
0 |
5 |
|
Differ |
5 |
5 |
|
0 |
|
Offline NA |
|
|
|
|
|
Supply |
4 |
0 |
0 |
0 |
|
Demand |
6 |
0 |
|
|
|
Balance |
7 |
9 |
|
|
|
Differ |
8 |
8 |
|
0 |
|
Virtual NA |
|
|
|
|
|
Supply |
3 |
6 |
0 |
|
|
Demand |
5 |
6 |
8 |
9 |
|
Balance |
6 |
6 |
7 |
0 |
|
Differ |
3 |
5 |
|
|
|
|
|
|
|
|
Image: A
This data has Product ( Online Na/Offline NA/Virtual Na) and has sub category details as Supply/demand/balance/Difference. This view is from Power Bi report.
Issue:
I am pulling this view from Power Bi report but actual output from BI is coming like this: Where rows are moving to column.
|
Product |
Month |
Supply |
Demand |
Balance |
Difference |
|
Online Na |
22-May |
10 |
10 |
10 |
5 |
|
Online Na |
22-Jun |
5 |
5 |
5 |
5 |
|
Online Na |
22-Jul |
|
0 |
0 |
|
|
Online Na |
22-Aug |
5 |
|
5 |
0 |
|
Offline NA |
22-May |
4 |
6 |
7 |
8 |
|
Offline NA |
22-Jun |
0 |
0 |
9 |
8 |
|
Offline NA |
22-Jul |
0 |
|
|
|
|
Offline NA |
22-Aug |
0 |
|
|
0 |
|
Virtual NA |
22-May |
3 |
5 |
6 |
3 |
|
Virtual NA |
22-Jun |
6 |
6 |
6 |
5 |
|
Virtual NA |
22-Jul |
0 |
8 |
7 |
|
|
Virtual NA |
22-Aug |
|
9 |
0 |
|
Image:B
Need help:
I am looking for this report in excel format for further analysis.
How can I convert this excel output , where I can get similar view as 1st image. May be we can use some formulas or create VBcode?
Can you help me with solution? Thanks is advance.
sdaha20 I would use PowerQuery to flatten the data that you refer to as "Image B". Then, create a pivot table from it as shown in the Query sheet.
