Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,665 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am trying through Power query but could not do it so far
I have two data sets
Table-1 it contains vehicle movement on particular dates
and Table-2 it contains check points between two zipcodes
now zip code is given in the first table as well. so that is the common column, next what i need is data by checkpoint name:
Result
Please help, thanks in advance
It's easy enough to do in a macro.