Forum Discussion

Jelto83's avatar
Jelto83
Frequent Visitor
5 years ago
Solved

Pivot Data into Lists without Aggregation/Counting or Summing the data

Hi,   I'm sure that this is going to be an easy solution for someone out there, but it's had me in circles the last few days.   Requirement: Users require a dynamic dependent dropdown list where ...
Need Help
  • Jelto83's avatar
    Jelto83
    5 years ago

    I've found an iterim own solution to this. I had to add an INDEX Column before Pivoting the data with out Aggretating it and it worked. Now have to format the data around but in essence it has sort of worked.  Would still love a better solution in the longterm - I'm guessing some sort of incremental counter against each Supplier ID

     

Smauro's avatar
Smauro
Solution Sage
5 years ago

Hi Jelto83 

 

You could try this, as a new step:

.

let
    names = List.Distinct(Source[SupplierNumber])
in
    Table.FromColumns(Table.Transpose(Table.Pivot(Source, names, "SupplierNumber", "SKU", each _))[Column1], names)

 

 

Changing Source to your previous step's name.