Does anyone know how to consolidate data from several Excel files, please?

helpful
Posting as :
works at
You are currently posting as works at

Power query if you’re combining similar data from multiple files.

like

This is the right answer!

Power query if you only have access to excel. It would be worth dropping it into the premium version of Claude.ai or ChatGPT and asking it to consolidate for you. I don’t think GPT does file creation yet, but Claude definitely does. Just give it clear instructions and it might be faster than you learning power query.

HOWEVER, depending on the data you have you may not want to put it into those AI systems. If it has personal information of students all that information gets stored in their databases. But you could replace personal info with fake names that you can map back maybe. Hope that’s helpful

like

Thank you!

What’s your end goal/ usage?

like

Power Query

like

You'll need to Google a few bits but from the Excel ribbon: Data > Get data > from folder.
Then filter the list to the files you want.
In the titles there will be a double arrow pointing up and down - click this.
This should get you 90% of the way there. Good luck.

like

Well done!

Is there a common identifier across each file

Then power query is your best bet

likesmart

Power Query.

Make sure you set you specify names to each of your Tables, before you use them into PowerQuery.

Power Query or learn Power BI quickly.

Related Posts

Do female and male journalists/reporters make the same amount of money as each other, or is there a pay divide?

like

The severance package at Meta for laid off employees almost makes it nice to be laid off depending on what your personal situation is….. personally wouldn’t mind getting 4+ months of full pay to reset and think about what’s next 😬

like

Wells Fargo Wellsfargo I am working in oracle and in production support project earning 12 lac... How much i can ask in hr discussion? Experience 7.5 years

How is Work Life Balance at HCL Technologies ?
Career Progression?
Job security?
Work from home ?
HCL Technologies

like

Hello All,
My skills sets are Automation testing using Selenium , Java.
My current CTC is 14.70 and have an offer of 18lpa fixed+3.60 lakhs variable pay.
Is it a good offer?
Also it's written in offer that need to travel to US.
Shall I get retained if I am offered a decent salary revision or shall I move out?

like

I have to fill out a background check form for a position and it asks if I've ever been discharged from a job. Does getting "the talk" --i.e. being told your future isn't at the firm as a senior associate--count as being discharged? Any thoughts are much appreciated!

like

Hey all thinking of relocating from Canada to Indiana. What is the average pay for an RN at parkview?

like
like

Leaving Goldman Sachs this month, if anybody wants a referral - feel free to DM your resume and the Job ID for which you'd like to apply.

Cheers!

like

Booking a last mintue trip to India over Christmas New Years. Anyone have any tips on best places to book business class? From JFK.

like

Anyone found an affordable adjustable standing desk they like? I have an iMac and a laptop is like to be able to fit on it.

like

Hi everyone,
I’m hiring for x3 Sr / Jr Application Security Engineers in my team.
UK based, team is 100% remote, although the office in London is there if you prefer.
Pre IPO unicorn valued FinTech startup.
Get in touch for more info 🙂

like

I only have Reg left. I failed it once before. For those who have passed Reg what were some of things you focused on? Also if you have any study tips I would really appreciate it, tax has never come naturally to me.

like

Where are the most opportunities in LS Consulting? I’m looking at moving to NYC but wondering if Boston or SF is a better play. Ideally prefer to be in an in-person/hybrid role.

like

Considering making a switch from Big 4. Comments to share on bonus this year and in a normal year? Culture?

Anyone have a standing desk recommendation between the Fully Jarvis vs Uplift V2 vs Autonomous Smartdesk 2? Leaning towards the Jarvis but the Autonomous one seems 50% cheaper, but can’t really tell what the drawbacks are according to their website/reviews

like

If you get a full time offer from the firm where you interned during your summer after your first year of MBA, will the offer pay for your second year of tuition?

like

Anyone have any information regarding a project in TCS - Business Solutions Cincinati ( Hi Tech vertical )

Project Code - 800150645

If anyone have any information regarding the project please let me know.

like

Additional Posts in Excel Genius

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

Does anyone know any shortcuts for the “Refresh All” button without having to always click Data->Refresh All every time I want to refresh the live data? For a Mac btw pls thanks!

Post Photo
like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Anyone know what these badges are?

Post Photo
likefunny

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

How do you fix microsoft excel cannot paste data error?

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal