Distinct Columns (as per Values) in Power Query
We have the UI Option in Power Query to Remove Duplicate Rows, but no such option to Remove Duplicate Columns. In this Video, we shall see how we solve for this problem.
---------------------------------------------------------------------------
Input --
Col_1 : A, B, C
Col_2 : P, Q, R, S
Col_3 : P, Q, R, S
Col_4 : X, Y, Z
Output --
Col_1 : A, B, C
Col_2 : P, Q, R, S
Col_4 : X, Y, Z
---------------------------------------------------------------------------
The main challenge in dealing with this case is retaining the Column names. We shall see two approaches to deal with this problem and explore many M Functions.