7 Replies Latest reply: Jul 8, 2016 9:48 AM by Rakesh Boorgu RSS

    Convert column headings into rows

    Shannon Marshall

      Hello,

       

      I have a table that has various columns with data.  Five of those columns I would like to make into a single column and use the headings as the row data.  Below is an example of what I am talking about.   Is there a way to code this to work?  I do not think an Inline table would work because the data can have multiple values.  Any help is greatly appreciated.

       

      The file I am trying to change is a QVD.  Is there a way for me to create another table to have the data the way I want and then join back to the original table to bring in the other data values I need?

       

      Thanks

      Shannon