Hi @jihenktari
Could you please show us the results that you need?
Currently, I would suggest you import the table into Power Query and transform the data.
- Select the table, then go to Data tab > Get & Transform Data group > From Table/Range.
- Press Ctrl key to select other columns except Slot, such as Amazon, airbnb, tesla and .etc > go to Transform tab > Any Column group > Unpivot Columns.
- Select the Value column > go to Transform tab > Any Column group > Pivot Column.
Choose the Attribute as Values Column, and select Don't Aggregate.
- We will get the table as following image.
- Please click Home tab > Close & Load to > Select the cell that you want to put this table.
Any misunderstandings, please post back.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.