Transpose multiple columns into one columns

[Anonymous]

Please help

What I have
Create Date	Assign Date	Modify Date	Complete Date	Sign Date	Receive Date
1/11/2018	1/16/2018	1/26/2018	2/25/2018	2/4/2018	12/19/2017
1/12/2018	1/17/2018	1/27/2018	2/26/2018	2/5/2018	12/20/2017

What I want to Achieve without using DAX but in Power Query
1/11/2018
1/16/2018
1/26/2018
2/25/2018
2/4/2018
12/19/2017
1/12/2018
1/17/2018
1/27/2018
2/26/2018
2/5/2018
12/20/2017

For more context, I just wanto filter out the latest date in the table and use it as my end date. Thank you in advance

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

what you do is the following:

select all the columns then in the unpivot columns option, select the unpivot only selected columns and it will be like the following screenshot

then you remove the  attribute column and rename the value column as you want

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[Anonymous]

Thank you