Forum Discussion
Solved
Power query for multiple columns (and multiple dates)
Hi, I am hoping to use power query to rearrange large plant sampling datasets, and part of this is transforming six columns into three. Datasets come from two sampling phases, so I have two dates, w...
If I understood the logic correctly, you may reference main query selecting related to date1 and date2 data and combine them together. Please see attached.
If I understood the logic correctly, you may reference main query selecting related to date1 and date2 data and combine them together. Please see attached.
Thank you SergeiBaklan, this is exactly what I was after!
I am new to power query so it took me a little while to work out how to replicate what you did, but making the two tables of the required information and then combining them should do what I need it to. My next step is to try it within an actual dataset. Thanks again!