Combining multiple tables with different measures?

[RCarter]

Hello,

Let me preface this by saying I am very new to PowerBI (and Data Analysis in general). I'm working on a project to bring some student metrics. I have each metric (GPA, SAT, ACT, and Headcount - seperated by year) in it's own table. The metrics I have on rows, and the years I have on columns. My issue is, I want to combine each table so that it looks like the excel screenshot I posted. Does anyone have any guidance?  

[v-zhangti]

Hi, @RCarter 

Can you simplify your source data table and provide some sample data for testing? Sensitive information can be removed in advance.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly