Excel How To Combine Lots of Tables in a Workbook

preview_player
Показать описание
This short video shows how to combine the data from lots of tables contained within one workbook.

Specifically:
- power query
- Excel.CurrentWorkbook()
- results table
- refresh when new tables
- how to filter to exclude the results table
- how to refresh

Chapters in this video:
00:00 - Introduction
00:14 - Exercise 1
01:24 - click-start
01:29 - Exercise 2
02:35 - Exercise 3

Also, check out these videos with time saving Excel Hacks:

  1. Excel University
  2. combine data in excel
  3. microsoft excel
  4. advanced excel
  5. power automate desktop
  6. power automate
Рекомендации по теме
Merge Multiple Excel 0:03:08

Merge Multiple Excel Files into 1 File in just few Seconds !!

AWESOME Excel trick 0:07:27

AWESOME Excel trick to combine data from multiple sheets

COMBINE Multiple Excel 0:05:58

COMBINE Multiple Excel WORKBOOKS into One | ExcelJunction.com

How to paste 0:00:32

How to paste multiple cells into one single cell in Excel

Combining Data From 0:06:07

Combining Data From Multiple Cells in Excel

How to get 0:00:20

How to get multiple columns under a single column? | Excel 2007

Combine all sheets 0:04:31

Combine all sheets into one in excel | Power Query (the easiest method!)

Consolidate Data in 0:05:27

Consolidate Data in Excel that has Multiple Duplicate Values On the Same Excel Worksheet

Fastest Way to 0:02:18

Fastest Way to Merge Cells in Excel | Merge Same Values/Duplicates in Excel

How to Do 0:01:14

How to Do a VLOOKUP With Two Spreadsheets in Excel

Combine all Excel 0:04:31

Combine all Excel files in one Task Automation with ChatGPT

Excel - Merge 0:09:05

Excel - Merge Data from Multiple Sheets Based on Key Column

Link Every Worksheet 0:06:05

Link Every Worksheet to a Master Sheet in Excel

How to Combine 0:02:09

How to Combine Multiple Excel Workbooks into one Workbook | Excel Tutorials for Beginners

Concatenate Excel Tutorial 0:05:29

Concatenate Excel Tutorial

How to Combine 0:07:20

How to Combine Multiple Excel Sheets or Workbooks Seamlessly

Excel Tips and 0:01:22

Excel Tips and Tricks #36 How to combine two graphs into one

Plot Multiple Lines 0:01:57

Plot Multiple Lines in Excel

Excel Tips 31 0:02:21

Excel Tips 31 - Add Multiple Lines to Text within Cells - Use the Enter key within a cell

How to Add 0:03:44

How to Add MULTIPLE Sets of Data to ONE GRAPH in Excel

How To Combine 0:01:52

How To Combine Multiple Rows In A Column In Excel || Excel Tricks || dptutorials

Multiply whole column 0:00:37

Multiply whole column by an specific value in Excel

How to quickly 0:04:29

How to quickly make multiple charts in excel

Consolidate Multiple Excel 0:03:59

Consolidate Multiple Excel Files into One Excel File in Hindi

Комментарии
Автор

I love your videos, they're short and sweet. However, if a sheet has no table and has a Named Range, it could be included as a table. I copied the values of a table to a new Worksheet and named the entire range of values to "Sheet1Range". The problem is that even though it looked identical to other tables, the first row is had not been promoted. After filtering Query1 I added the following:
=Table.AddColumn(Source, "Custom", each if <> "TransID" then else [Content])
That checks to see that gets the field names of the top (first) row of the table and promotes the headers in the table if the first column is not named "TransID".
Still a great video!

jerrydellasala
Автор

Boom! Seems a little more efficient then VSTACK.

bczaru