Forum Discussion
Combine 2 unique row entries from a table into 1 consolidated row entry
Yes, but it depends on how you like working with query. You can make all the sheets tables and import data as a query and then rename the columns.
But what it sounds like is you really want is an automated pull each month.
This will help. It’s high level stuff, but go slow and pause often. There are a few clicks he does that he doesn’t explain and it can cause you a little trouble.
https://youtu.be/ktgdDPNXiMg?si=Wx2DML9APbpUzgs5
or worse (better)
https://youtu.be/0ZOY8is-bgY?si=sLXJyFkjiSLUYvtX
One thing to keep in mind is that the way you undo something in Query is to delete the step in the query history.
Oh… if you cannot find PowerQuery, tab Data… GetData… slide down to Launch Power Query Editor
else… watch some of guy in a cube videos.
Good luck! Keep us posted. -mm