by Wyn Hopkins

Select Range and Convert

To kick off 2022 we thought we would put this Power Query challenge to you:

Select Range and Convert to required result
Solution should work when dates, codes, colours wording or numbers in Value column change
Note the colours in the Required Result are for guidance purposes only and are not part of the challenge

If you’d like us to look at your answer send us a copy to info@accessanalytic.com.au and we’ll also add a link to your solution at the bottom of this page unless you’d prefer us not to.

Flex your Power Query skills with our free download.

Our solution…

The new year challenge certainly got some traction and we have quite a few solutions to share. Thanks as always for taking the challenge and sharing your thoughts: