Copy sheets from one workbook to another using Control/Command+click. Sheets can be moved to new workbook with customizable placement. Merged files aren't automatically synchronized with original
Power Query combines data from multiple Excel files into one worksheet. Files must be stored in a single folder for merging. Data structure must match across all files. Files are loaded into Power Query editor through "From Folder". Combined data can be transformed and merged into single table
Text to Columns feature splits text by delimiter or character count. Formulas can split text using dynamic array with SEQUENCE function. Flash Fill detects patterns in data entry (Excel 2013+). Power Query offers multiple splitting options under Data tab. VBA provides Text to Columns feature or Split function methods
Power Query uses TRY OTHERWISE instead of IFERROR for error handling. Custom Columns can be used to track errors and their causes. Error records contain Power Query and Excel error information
Insert new row above data by clicking row number. Double-click new cell to enter column title. Press Tab to skip to next title cell. Column headers remain unchanged (A-Z letters)
Available only in Microsoft 365 for Windows. Uses Power Query to import tables from PDFs. Tables are organized in columns and rows as in PDF. Requires selecting cell, clicking Data > Get Data > From PDF. Tables are labeled by page numbers