Forum Discussion
Moving Items from Sheet to Sheet
I am in receipt of an Excel workbook with ten sheets that each have more than 50,000 lines of data. I have made a tables of all data on each sheet. The client wants all data on one sheet (for o...
Patrick2788
Edit -
Got it! The second line was missing a number for the sheet.
*******************************************************************
How do I edit the formula so that the heading doesn't repeat.
Updated above*
=LET(Stack,VSTACK(Sheet2:Sheet13!A2:R66000),FILTER(Stack,TAKE(Stack,,1)<>""))A sample workbook with the same arrangement (and much less data) is attached.
Patrick2788
Thank you for your patience. I still can't get it.
Only sheet1 has header; This is what I got.You have to remove the structured reference (bolded part):
=LET(header, Sheet1!A1:R1,stack, VSTACK(Sheet1: [Jun 3 - Oct 11 2019]:[Dec 7 - Mar 9 2023]!A1:R60000),filtered, FILTER(stack, TAKE(stack, , 1) <> ""),VSTACK(header, filtered))Patrick2788
How about this one?
There are 8 - 10 sheets (I'm not including 'TestSheet'), from June - December.
Excel doesn't like my formula.=LET(header, Sheet1!A1:R1,stack, VSTACK(Sheet1: [Jun 3 - Oct 11 2019]:[Dec 7 - Mar 9 2023]!A1:R60000),filtered, FILTER(stack, TAKE(stack, , 1) <> ""),VSTACK(header, filtered))- Tried the below a got an error that says "You've entered too few arguments for this function."
=LET(
stack, VSTACK(Sheet4:Sheet6!A2:R66000),
filtered, FILTER(stack, TAKE(stack, , 1) <> "")) If you're supplying header yourself, then you may use:
Revised
=LET(stack, VSTACK(Sheet4:Sheet6!A2:R66000),FILTER(stack, TAKE(stack, , 1) <> ""))
