Forum Discussion
ddiorio16
Mar 06, 2021Copper Contributor
Sorting Data from one table to a second table
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...
Riny_van_Eekelen
Mar 06, 2021Platinum Contributor
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]<>""))