How can change data format to desired format as posted below ?

[Crazydog]

Current View: 

Desired View:

I want all start dates row wise and so the end dates. 

Thanks in advance! 

[amitchandak · Accepted solution]

@Crazydog , First unpivot data. The split data two columns using the first occurrence and then pivot again using the column have start and end date

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12

Split column and Combine Columns: https://youtu.be/T30H_fe2uAA