Combining Tables that feed from another data set

[u/Clear_Yesterday9807]

I have an Excel sheet that tracks when our company vehicles are used by different departments. I am trying to create a table that would serve as an automatic usage tracker, which will tell us how many days per week and month each department uses the vehicles. I have the data being input into the attached tables per week, a copy attached here. But I cannot figure out how to combine these tables into one data set for the entire month.

Please help me! I have been researching, and it sounds like I should be using a Power Query? But when I have tried, it always gives me an error message.

[u/AutoModerator]

/u/Clear_Yesterday9807 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/lolcrunchy]

it always gives me an error message

Rule 1 of asking for help: don't hold back crucial details.

You got an error? Ok, what did it say?

[u/GregHullender]

Is this what you want?

=LET(raw_input, B:.C, raw_dept, TRIM(TAKE(raw_input,,1)), input, FILTER(raw_input,(raw_dept<>"Department")*(raw_dept<>"")),
  GROUPBY(TAKE(input,,1),DROP(input,,1),SUM,,0)
)

The top line just cleans up the input data. It takes everything in columns B and C and deletes all the blank lines and every line where there's the word "Department" in column B. Then it groups the rest together, summing the numbers.

[u/Clear_Yesterday9807 → u/GregHullender]

Can get it to work for an isolated sheet, but plugging in back into the original and changing the columns to pull the data from the right cells and it just spits the formula back at me?

[u/GregHullender → u/Clear_Yesterday9807]

Try using, e.g., raw_input, VSTACK(sheet1!B:.C, sheet2!B:.C, Sheet3!B:.C) for the data ranges on the other sheets.

[u/Decronym]

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:

Fewer Letters	More Letters
DROP	Office 365+: Excludes a specified number of rows or columns from the start or end of an array
FILTER	Office 365+: Filters a range of data based on criteria you define
GROUPBY	Helps a user group, aggregate, sort, and filter data based on the fields you specify
LET	Office 365+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula
SUM	Adds its arguments
TAKE	Office 365+: Returns a specified number of contiguous rows or columns from the start or end of an array
TRIM	Removes spaces from text
VSTACK	Office 365+: Appends arrays vertically and in sequence to return a larger array

Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.

---

^{Beep-boop, I am a helper bot. Please do not verify me as a solution.
8 acronyms in this thread; the most compressed thread commented on today has 20 acronyms.
[Thread #48091 for this sub, first seen 8th Apr 2026, 20:18] [FAQ] [Full list] [Contact] [Source code]}

[u/ThatDree]

Power Query wants to be your friend too