Transform Table

[shep123]

I am not sure if this is the appropriate title for my question but ulitmately what I want to do is take a table as such:

Survey_Key	Q1	Q2	Q3
A	4	2	5
B	3	3	5

and turn it into this:

Survey_Key	Question	Answer
A	Q1	4
A	Q2	2
A	Q3	5
B	Q1	3
B	Q2	3
B	Q3	5

The only way I can think of right now is to split the query up into multiple queries with only the Survey_Key and one question column each, create columns for the question number and answer, and append them together. I have 10 or so questions so I would like to avoid that as I imagine there has to be a more efficient way.

[danextian · Accepted solution]

Hi @shep123,

In the Query Editor, do the following.

Select Survey_Key column and right-click on it.

Select Unpivot Other Columns. This should place the column headers in the newly created column Attribute and the row in Values column. 

Note: if your Q columns have null values, replace them with something else link "blankvalue" prior to unpivoting your column as the null rows get deleted with unpivoting. Once you're done unpivoting, replace "blankvalue" with null.