Table transformation List.Distinct ?

[n8schicht]

Hello everybody, 

@v-yiruan-msft 
You have helped me so well with this topic:
https://community.powerbi.com/t5/Desktop/Tabel-tansformation-need-help/m-p/1734060#M683562

that I wonder if you also have an idea here:

I have a second table:

first row -> Artikelnumber
second row -> Attribute Name
third row -> Attribute Value

I would like to build the following data structure from this data:
Article number; Attribute-Name_1; Attribute_Name_2; etc ..... depends dynamically on the number of attribute names, i.e. my target table gets wider and wider depending on the existing attribute names

[nvprasad · Accepted solution]

Hi,

You can do this using pivot transformaiton in the Query editor.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad