From column in rows to new row with first column

[dgiovannie]

Can someone help me out with this problem?
I got a table like this:

Date	C1	C2	C3
01-01-2024	Steve	Danny	John
02-01-2024	Harry
03-01-2024	Nathan	Peter

What I try to accomplish is the following table

Date	Name
01-01-2024	Steve
01-01-2024	Danny
01-01-2024	John
02-01-2024	Harry
03-01-2024	Nathan
03-01-2024	Peter

Does anyone know how to accomplish this with Power Query?

[AlienSx · Accepted solution]

select Date column and Unpivot Other Columns in UI (then filter if required and remove column with C* )