Forum Discussion

Jamming_Mon's avatar
Jamming_Mon
Frequent Visitor
6 years ago
Solved

Power Query - Merging Multiple Columns and Removing Duplicates and unnecessary data in Columns

Hello,   I'm trying to merge multiple invoice columns into one.  Here's what I'm trying to do.  1.  Remove Duplicate invoices found in all columns 2. Remove certain texts like TBD, Unknown etc an...
Need Help
Tips and Tricks
Tutorial Requests
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Jamming_Mon ,

     

    Power Query:

     

    1. Mark all columns and "Transform" --> "Unpivot Columns"

    2. "Home" -->"Choose Colums" select "Value"

    3. "Text Filters" on Column "Begins with..." = "INV"

    4. "Transform" --> "Extract" --> "Text After Delimiter" = "INV"

    5. "Home" --> "Remove Rows" --> "Remove Duplicates"

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Jamming_Mon ,

 

Power Query:

 

1. Mark all columns and "Transform" --> "Unpivot Columns"

2. "Home" -->"Choose Colums" select "Value"

3. "Text Filters" on Column "Begins with..." = "INV"

4. "Transform" --> "Extract" --> "Text After Delimiter" = "INV"

5. "Home" --> "Remove Rows" --> "Remove Duplicates"