Forum Discussion

lbudack's avatar
lbudack
Icon for Advocate III rankAdvocate III
6 years ago

Combine multiple tables on same sheet from Excel efficiently

My current model works, but I'm sure there's a better, more efficient way to do this that I'm missing. Every time I have to add a staff member, I have to adjust some of the steps in my model to get i...
Need Help
lbudack's avatar
lbudack
Icon for Advocate III rankAdvocate III
6 years ago

Thanks, but that's not really my issue. My issue is combining tables that are on one sheet instead of multiple. 

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

When you say "tables", do you mean they are formatted as tables?  If so, those will show up in query as distinct entities (Kind = Table instead of Kind = Sheet).  If not, you should do that and use the Tables to extract the data instead of sheets.  If you are already doing that, please clarify your issue (pics aren't obvious to me at least).

Regards,

Pat