Merge Pivot Combined Columns into rows on Power Query

[Aldonin]

Hi, I'm creating a new thread since the problem I'm trying to solve is different to similar solutions which I've tried unsuccessfully.

I have a table with the following structure (see below), column "A" provides a list of cities A,D,B...D Column "B provides dates for the 1st date of an event happening at each city. Column "C" provides the dates for the second event at each city.

	A	B	C
1​	City	Date 1	Date 2
2​	A	4-Apr​	5-May
3​	B	5-Apr​	6-May
4​	C	6-Apr​
5​	D	7-Apr​	8-May
6​
7​
8​
9​

I'm trying to bring all the dates for both events into a single column as shown in the example below: Column "B". While I'm able to pivot columns into rows using Power Query's Split function (as learnt on a separate thread), I'm unable to solve this specific problem since the data across two separate columns "B" and "C".
Any Power Query ideas to solve this would be awesome, thanks in advance everyone!

	A	B	C
1​	City	Date 1	Date 2
2​	A	4-Apr
3​	B	5-Apr
4​	C	6-Apr
5​	D	7-Apr
6​	A	5-May
7​	B	6-May
8​	D	8-May
9​

 

[lrobbo314]

Like this.

SJ_TableToExcel_Pivot.xlsx
	A	B	C	D	E	F	G
1	City	Date 1	Date 2		City	Attribute	Date
2	A	4/4/2021	5/5/2021		A	Date 1	4/4/2021
3	B	4/5/2021	5/6/2021		A	Date 2	5/5/2021
4	C	4/6/2021			B	Date 1	4/5/2021
5	D	4/7/2021	5/8/2021		B	Date 2	5/6/2021
6					C	Date 1	4/6/2021
7					D	Date 1	4/7/2021
8					D	Date 2	5/8/2021
Sheet5

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Unpivot = Table.UnpivotOtherColumns(Source, {"City"}, "Attribute", "Date")
in
    Unpivot