Data transform using power query

[Anonymous]

Could you please someone suggest me for below issue. Thank you in advance.

I have below format data 

2026	actual			budget
	p1	p2	p3	p1	p2	p3
revenue	1	2	3	4	5	6
food cost	7	8	9	10	11	12
2025	actual			budget
	p1	p2	p3	p1	p2	p3
revenue	1	2	3	4	5	6
food cost	7	8	9	10	11	12

How can I transform this data to below format

subject	year	period	Actual	budget
revenue	2026	p1	1	4
revenue	2026	p2	2	5
revenue	2026	p2	3	6
food cost	2026	p1	7	10
food cost	2026	p2	8	11
food cost	2026	p2	9	12
revenue	2025	p1	1	4
revenue	2025	p2	2	5
revenue	2025	p2	3	6
food cost	2025	p1	7	10
food cost	2025	p2	8	11
food cost	2025	p2	9	12

[v-echaithra · Accepted solution]

Hi @Anonymous,

The updated PBIX file is attached for your reference.
Here, the data has been reshaped to the required format (Subject, Year, Period, Actual, Budget) using Power Query so that it can be used directly for reporting and further analysis.

Please review the updated file and let us know if everything looks good or if any additional adjustments are needed.

Thank you.

[v-echaithra]

Hi @Anonymous ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-echaithra · Accepted solution]

Hi @Anonymous ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.

[v-echaithra · Accepted solution]

Hi @Anonymous,

The updated PBIX file is attached for your reference.
Here, the data has been reshaped to the required format (Subject, Year, Period, Actual, Budget) using Power Query so that it can be used directly for reporting and further analysis.

Please review the updated file and let us know if everything looks good or if any additional adjustments are needed.

Thank you.

[Anonymous]

Thank you for solving this issue. I helped me a lot.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

@lbendlin Thankyou for your recommendation. I updated the data sample. Can you please suggest how to do it?