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...
=LET(
header, Sheet!A1:R1,
stack, VSTACK(Sheet4:Sheet6!A2:R60000),
filtered, FILTER(stack, TAKE(stack, , 1) <> ""),
VSTACK(header, filtered)
)
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*
If you're supplying header yourself, then you may use:
Revised
=LET(stack, VSTACK(Sheet4:Sheet6!A2:R66000),FILTER(stack, TAKE(stack, , 1) <> ""))