Combining small tables in worksheets that have the same column structure and names is a simple task. But if you had to combine or append the tables from a workbook that had a LOT of worksheets (or tabs), that would be a mind numbing exercise. Also how would you know what worksheet name it came from? With the small worksheet example you could create a helper column and manually enter the worksheet name for those respective table.
If there's 10 or more worksheets (30? 40?), that'll be painful and you might think about learning VBA to do this. Fear not because with a few clicks in Power Query, it can be done in less than 3 minutes.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.