使用 Google 电子表格从行到列的交叉制表

Question

>我有一个表格，上面有每个受访者的问题和答案，我希望将所有问题都表示在一列中。有些人不会回答所有问题。

例如，转换这个：

+---------+----------------+---------+
| User_ID | Question_Title | Answer  |
+---------+----------------+---------+
|       1 | Question One   | Answer1 |
|       1 | Question Two   | Answer2 |
|       1 | Question Three | Answer3 |
|       2 | Question One   | Answer4 |
|       2 | Question Two   | Answer5 |
|       3 | Question One   | Answer6 |
+---------+----------------+---------+

成：

+---------+--------------+--------------+----------------+
| User_Id | Question One | Question Two | Question Three |
+---------+--------------+--------------+----------------+
|       1 | Answer1      | Answer2      | Answer3        |
|       2 | Answer4      | Answer5      | --             |
|       3 | Answer6      | --           | --             |
+---------+--------------+--------------+----------------+

我尝试了数据透视表，但它们似乎不适用于文本值。有什么线索吗？

Answer 1

=QUERY(A1:C7,"select A,max(C) group by A pivot B ")

其中 A 是用户 ID，C 是答案列，B 是问题列。 获取数据后，如有必要，请使用筛选器/数据透视表/其他QUERY来排列它们。