• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Query Data Transform


Well-Known Member
What is the criteria for each color. Once this data is brought into PQ, it loses all colors. So for this to be sorted, it needs to have some other criteria that can be executed on.


Yes, you are true in power query colors do not work. The only criteria is that if column 1 values are present in column2 or column3 then they should be shuffled to column1.


Excel Ninja
Is first 3 row always going to hold correct values that belongs that column?

And does those 3 rows hold all the values that could appear in the given column?