Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

convert table headers

Hi,   I have a table1 mentioned below, i need the list of table headers as a dropdown list.     REgards, Varun
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    Select all column headers expect for [TABLE1] and click "Unpivot columns".

     

    Drag [Column Type] into a slicer, and use a Matrix to display above table.

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous ,

 

Select all column headers expect for [TABLE1] and click "Unpivot columns".

 

Drag [Column Type] into a slicer, and use a Matrix to display above table.

Best regards,

Yuliana Gu