Power Query to transform current table

Hello Experts!

I need Your help, I've got table with many ID products.
Please can some1 take a look and help me with query ?

I need something like i've made manually in file ( table below )

thanks in advance !

Which table in the workbook is the 'before' and which is the 'after'?

Please try

Please Login or Register  to view this content.

Vixx1

Why do you want/need the data in this format?

The following is a formula based proposal:
1. Produce a distinct list of Properties, as modeled in H38:H42, using: =IFERROR(INDEX(Table2[Property],MATCH(0,INDEX(COUNTIF(H$38:H38,Table2[Property]),,),)),"")
2. Produce a distinct list of Product ID's, as modeled in J1:J5, using: =IFERROR(INDEX(Table2[Product ID],MATCH(0,INDEX(COUNTIF(J$1:J1,Table2[Product ID]),,),)),"")
3. Produce a list of column headers, as modeled in K1:Y1, using: =IF(MOD(COLUMNS($A1:A1),5)=1,INDEX($H39:$H42,ROUNDUP(COLUMNS($A1:A1)/5,0)),IF(MOD(COLUMNS($A1:A1),5)=2,"Yes",IF(MOD(COLUMNS($A1:A1),5)=3,"No",IF(MOD(COLUMNS($A1:A1),5)=4,"store","fast delivery"))))
4. Produce a row of Properties, as modeled in K38:Y38, using: =IF(MOD(COLUMNS($A1:A1),5)=1,K1,J38)
5. Fill J2:Y5 using: =IF(SUMPRODUCT((Table2[[Yes]:[fast delivery]]="X")*(Table2[[Product ID]:[Product ID]]=$J2)*(Table2[[Property]:[Property]]=K$38)*(Table2[[#Headers],[Yes]:[fast delivery]]=K$1)),"X","")
For future reference please put enough data in the file so that we can know formulas/code need to accommodate things like multiple ID's.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.