Fetching column names from table

Hi All,

wanted to fetch all the column names from a particular table, either as a row in that same table or as a measure. I was hoping to have all the column names as  a selectable value in the table, rather than just a heading. 

Also if possible somehow have a table rows and coulmns interchanged as in transposing them. 

Thank you