Duplicate a column of data from a table into new, sorted table

I have a table of apartment lease dates but the source table is sorted on the unit number. I'd like to chart the lease expiration dates but need a duplicate of the lease expiration column that can be sorted separately.

The source table has the unit number and lease expiration data copied into an Excel table that automatically expands as the data is copied into it (as tables will do). I'd like it if a separate table could duplicate the expiration column which I could trigger to update (both in data and number of rows) from the source table and then sort itself. Since this will go into a template that will be used for various scenarios, the number of rows in these tables will vary so it's not a set number

Please Login or Register  to view this content.

Attached is the example with a bit more description. The charting portion of my original post is not critical but the issue of data sorting from the source table into a new table is the challenge.

thanks...

Sorting and Charting.xlsx

Small....of course....thank you.

That works great!