Make dates in rows into columns order by date

Question

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:

NameLast nameHouse #Purchase DateOwnership %JohnSmith 3211/28/202198%JohnSmith 3218/29/20115%JohnSmith 3215/30/201545%

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.

NameLast nameHouse #Purchase DateOwnership %8/29/20115/30/20151/28/2021JohnSmith 3211/28/202198%  98%JohnSmith 3218/29/20115%5%  JohnSmith 3215/30/201545% 45% Total    5%45%98%

Qiu · Answer

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

I do hope there is another smarter way.

0503-Holidayday.yxmd

apathetichell · Answer

Like this?

housing sales.yxmd