Forum Discussion
Solved
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...
- 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!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})))
- Hi,
Thank you for your response!
I do have the latest version with 365 (mac though)
What I forgot to mention is that the tables are made up of many more columns, but the 2 I need to sort by are priority and price.
How would you handle this if in your workbook on sheet 1, 2 and 3 there were multiple columns, but you only want to see priority and price?
Thanks again!
