Forum Discussion

wkolcz's avatar
wkolcz
Frequent Visitor
4 years ago
Solved

Turning duplicates rows into additional columns for distinct rows

I have seen a number of examples on here using 2 columns but they don't seem to work for me. I have a datasource that has a list of product brand, part number, product name, images that can contain d...
Need Help
  • ImkeF's avatar
    ImkeF
    4 years ago

    Hi wkolcz ,
    I would group them and add a nested index to the grouped values: NestedIndex in PowerBI - YouTube
    Then pivot on that column so that they become the new column names.

     

ImkeF's avatar
ImkeF
Community Champion
4 years ago

Hi wkolcz ,
I would group them and add a nested index to the grouped values: NestedIndex in PowerBI - YouTube
Then pivot on that column so that they become the new column names.

 

  • wkolcz's avatar
    wkolcz
    Frequent Visitor
    4 years ago

    Thank you for the answer! It worked like a charm. Only issue I had was I forgot to click advanced when pivoting and selecting Don't Aggregate which makes a world of difference lol.