Forum Discussion
Index and match
Dear community members, I am very new to power query and just made my first steps. Until now I've just created connections, filtered and sorted the data queries. My question: I have 3 tables an...
I've now pivoted the column "activity number" in the table "confirmations.
From there I copied the table and filtered for "activity number = 0010", the same for the other numbers. Then I joined the two tables (order information and confirmation) for the time column)
That doesn't feel right to have a new query for each "activity number". Isn't there a smarter way?
Any suggestions?