Transpose data

[Anonymous]

Hi I currently have a data set that looks like this:

I want to transpose this data so that the PackageID is listed as one entry per row, with the sequential progress though the stages (1-4) listed as columns with the values for the time as entries:

 Can anyone assist?

@amitchandak- you are a whiz - can you help?

[Barthel · Accepted solution]

Hey, for this you need to pivot the data in Power Query.

Select the 'Time to complete stage' column, and use sum.