PowerBI或Excel:根据列中的唯一值创建列

Question

我有一个Excel文件，其中包含以下格式的翻译：

Field       |  Language  |  Translation
startbutton    English      Start
startbutton    French       Démarrer
stopbutton     English      Stop
stopbutton     French       Arrêter

但我想用这种格式：

Field       |  English   |  French
startbutton    Start        Démarrer
stopbutton     Stop         Arrêter

如何实现这一点我已经用PowerQuery尝试了一些东西，但没能得到想要的结果。。。

Answer 1

let
Source = Table.FromRows(
Json.Document(
Binary.Decompress(
Binary.FromText(
"i45WKi5JLCpJKi0pyc9T0lFyzUvPySzOALKCQeJKsTroKtyKUvOSQQpcDq/MTSwqSi2CKsovwGpKfgGmPNwMx6Kiw6tKQEbEAgA=", 
BinaryEncoding.Base64
), 
Compression.Deflate
)
), 
let
_t = ((type nullable text) meta [Serialized.Text = true])
in
type table [Field = _t, Language = _t, Translation = _t]
), 
#"Changed Type" = Table.TransformColumnTypes(
Source, 
{{"Field", type text}, {"Language", type text}, {"Translation", type text}}
), 
#"Pivoted Column" = Table.Pivot(
#"Changed Type", 
List.Distinct(#"Changed Type"[Language]), 
"Language", 
"Translation"
)
in
#"Pivoted Column"