Forum Discussion
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...
Thanks, but that's not really my issue. My issue is combining tables that are on one sheet instead of multiple.
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
