Help with data for a line chart

[jblackburnHWGA]

Hi this is school related. I have attendance data that comes in weeks column by column.

example below. The first column is the student, the following columns are the weeks showing the percentage of attendance for that week.

student	week 1	week 2	week 3
a	99	56	99
b	99	89	99
c	97	99	100

I want a line graph or bar chart it to show week as the X and percentage as the Y. The year groups will be the legend showing the average attendance of each year group per week. I havew this data linked in off another table. 

I'm working in the idea i need to change the layout as follows

week	student	attendance
1	a	99
1	b	98
1	c	78
2	a	98
2	b	90
2	c	89
3	a	100

I can't change how it comes out of the database/MIS. I need to change it in BI

[jblackburnHWGA]

That was quick. I couldn't figure out what i was looking for. I didn't know you could pivot select columns. Something new learnt

[amitchandak · Accepted solution]

@jblackburnHWGA , Unpivot week columns in power query

https://radacad.com/pivot-and-unpivot-with-power-bi