Excel - 将列中的值分成两列

Question

我有两列看起来像这样:

Data A  | Data B
-----------------
Type1   |  23
Type2   |  19
Type1   |  3
Type2   |  9
Type1   |  9

我想把它分成:

Type1 | Type2
-------------
23    |  19
3     |  9
9     |  

这通常如何在 Excel 中完成？

Answer 1

...同时在 Google 表格中...

={"Type1","Type2";{FILTER(B1:B,A1:A="Type1"),FILTER(B1:B,A1:A="Type2")}}

={"Type1","Type2"; 
  ARRAYFORMULA(TRANSPOSE(SPLIT(TRANSPOSE(SPLIT(
  JOIN("♦",FILTER(B1:B,A1:A="Type1"))&"♥"&
  JOIN("♦",FILTER(B1:B,A1:A="Type2")),"♥")),"♦")))}