Transposing and creating a table with Dates

[Anonymous]

Hi @PBI 

Trying to transpose cities and have a table with all dates by City. Attempting to acheive the image after this table.

Countries	Cities	Entry date	Exit date	Travel Date	Stamp Date
Belgium	Brussels	3/12/2019	5/12/2020	12/10/2018	11/5/2018
Japan	Osaka	10/18/2019	9/30/2019	10/15/2019	6/12/2019
England	London	2/14/2017	2/27/2017	2/12/2017	1/1/2017
Switzerland	Zurich	5/22/2019	10/12/2019	5/20/2019	3/12/2019
Finland	Helsinki	12/8/2020	3/6/2021	10/3/2020	7/1/2020
Belgium	Antwerp	3/15/2019	5/4/2020	3/12/2019	12/17/2018
Japan	Tokyo	10/18/2019	9/30/2019	10/15/2019	6/12/2019
England	Bristol	2/14/2017	2/27/2017	2/12/2017	1/1/2017
Switzerland	Lugano	5/22/2019	10/12/2019	5/20/2019	3/12/2019
Finland	Oulu	12/8/2020	3/6/2021	10/3/2020	7/1/2020

[AntrikshSharma · Accepted solution]

@Anonymous Are you trying to create a visual like the following? The file is attached below my signature:

[Anonymous]

Thanks for the feedback, that was super helpful pointing me towards a matrix table, I was trying to use just a table only. however I will like to include countries in row and get this result below: