Sorting Data from one table to a second table

[ddiorio16]

Hello! 

I'd like to sort the data in a second table I created based off the data in the first table. I've attached a screenshot to help clarify my question. 

I would like the data in "Table 2" to be sorted by the data in Column F of "Table 1" in descending order. So I'd Like Amex & Credit One to appear on the first two lines, followed by First Premier, Etc. I'd also like all the data in Rows C, D & E to be included.  

I know there is probably a very simple solution to this - but I'm an excel novice so tak

[#2]

@ddiorio16 Is there a particular reason why you want to duplicate everything in a second table? If there is none, just sort the data in Table1 and add the "Pay?" column to it.

Otherwise, a dynamic array formula like below could work, provided you are a MS365 subscriber.

=SORT(FILTER(Table1,Table1[CREDITOR]<>""))