Transpose Data like this

[Mahmed1]

Hey,

i have a table where i have 

Date...Code....Hours....Import Date

23/06...Leave...6.5.......14/06....

23/06...Leave...6.5.......15/06....

23/06...Leave...7.5.......16/06....

23/06...Leave...5...........21/06...

etc

how can i change the data using power query so it has all the import date across and code in a row with hours in between so i can see the change in hours day by day split by import date

so result like this

Date Selected 23/06

result

Code   14/06...15/06....16/06....21/06

leave.   6.5........6.5..........7.5..........5

i basically want to transpose all the import date and split the code into rows and have the hours split by import date so i can see how the hours changed on each import date for that code

hope this makes sense

i can do this in excel with formulas but was hoping i can achieve this ouput via powerquery

i dont have access to excel to load this into a view

i can have multiple codes but i only gave leave as an example

thank you

[BA_Pete]

Hi @Mahmed1 ,

You don't need to do anything with the data in Power Query - it's already in the perfect structure.

If you want to see the change in values, then put your data either into a Pivot Table or Chart if you're using Excel, or into a Matrix visual or Chart if youre using Power BI.

Pete

[Mahmed1]

Thank you