Forum Discussion
PQ Help with Arranging Tables for Relationships
I think this is a relatively straightforward one but I cannot for the life of me figure it out. I have some survey data that has respondents in rows and questions in columns with the responses to eac...
Hi Anonymous,
Select the Person column in Table 1, on the Transform tab select: Unpivot Columns, Unpivot Other Columns
Now you can Merge Table 1 and Table 2 setting the appropriate fields as keys (hold down CTRL when you select more than one combination) like so, the [Attribute] from Table 1 with Column 1 from Table 2 AND the [Value] from Table 1 with Column 2 from Table 2
Ps. If this helps solve your query please mark this post as Solution, thanks!
Thanks m_dekorte that was exactly it. Still not got my head around unpivoting but it seems really powerful!