How to Transpose part of a table

[ruby18]

Hi There Please can someone advise me how I could create a new table (TABLE02) in my data model which is sourced by transposing some element of my current table (TABLE01). So, in my new table (TABLE02) I want to have some Rows transposed into columns whilst remaining Rows remain as rows (so the data duplicates). Below is an example of what I am trying to achieve;

[v-qiuyu-msft · Accepted solution]

Hi @ruby18,

You can open Query Editor, select these columns: Question01, Question02, Question03, then select Unpivot Columns. 

Best Regards,
Qiuyun Yu 

[rkelly12]

Life saver!