Transpose a table using power query

[crookesa]

Hi,

I have a table which has the first column as a single date and then 4 more columns each representing a name. So one 4 people can be associated with one date.

I am trying to create a query to list all the names in the first column and have their corresponding date in the second column.

I've tried using the transpose functuon but it's not working and was hoping for some vlookup function but that's not working either, any suggestions to point me in the right direction to progress my query.

Thanks

 

[RoryA]

You should be able to select the date column then use the Unpivot Other Columns option.