Forum Discussion
user12690
Sep 14, 2022Copper Contributor
Question about combining data from multiple tables
Hi, My problem is a bit complicated, but I suspect that the solution isn't too difficult. I have 3 tables, on 3 different sheets in my workbook. They contain a list of data with one column "priorit...
- Sep 14, 2022
Harun24HR
Sep 14, 2022Bronze Contributor
user12690
Sep 14, 2022Copper Contributor
I already figured it out. It was =SORT(VSTACK(Table1,Table2,Table3),{1,10},{1,1})
since the data is on the 10th row.
Thanks again!
since the data is on the 10th row.
Thanks again!
- Patrick2788Sep 14, 2022Silver Contributor
Here's another approach to picking out the columns:
=LET(arr_constant,{"Priority","Price"},stack,VSTACK(Table1,Table2,Table3),select_col,CHOOSECOLS(stack,XMATCH(arr_constant,Table1[#Headers])),VSTACK(arr_constant,SORT(select_col,{1,2},{1,1})))