Make dates in rows into columns order by date

[Holidayday]

Hello, can you please me figure out how to get dates in a row also appear in a column? Please see the below as an example. Thank you so much!

BEFORE:

Name	Last name	House #	Purchase Date	Ownership %
John	Smith	321	1/28/2021	98%
John	Smith	321	8/29/2011	5%
John	Smith	321	5/30/2015	45%

AFTER:  I need to make the dates also appear in a column and ordered by the date. And a total that show the %. 

I'll have more than one names in my real dataset.

Name	Last name	House #	Purchase Date	Ownership %	8/29/2011	5/30/2015	1/28/2021
John	Smith	321	1/28/2021	98%			98%
John	Smith	321	8/29/2011	5%	5%
John	Smith	321	5/30/2015	45%		45%
Total					5%	45%	98%

[apathetichell]

Like this?

[Qiu]

@Holidayday 
Turned out to be a tricky one if we want to make it fully dynamic.

I do hope there is another smarter way.