Convert dynamic amount of date rows to columns

[RaptorFox]

Dear community

I have multiple CSV blobs in a particular storage container. Those are pulled from our backup system once a week for the last seven days. Each row indicates the system to be backed up, and then n-amount of date-named columns show if the backup was successful on this particular date (1) or not (0).

I need to be able to use date slicers in my dashboard and provide an easy overview. Therefore, i need one row per system per date for the dynamic amount of dates (columns) like this:

I now tried 3 hours, and need to give up. How can i do this conversion in the easiest way?

Thank you very much for any help! 

[RaptorFox]

Thank you very much, it worked perfectly! 

[AlexanderPrime · Accepted solution]

Hi there. 

Have you tried in Power Query selecting all the columns except the System Column and then using the "Unpivot Columns" function?

Doing that should give you an output like this:

Then you'd just need to rename the 2 columns it created and you should be good to go.