Transforma Tabela Power Query.

[EdsonGomes]

Olá, como transformar a 1º Tabela, para ficar igual a 2º Tabela?

Reparem que a coluna 1 e coluna 2 tem valores repetidos.

Obrigado.

[EdsonGomes]

Obrigado, funcionou 🙂

[BA_Pete · Accepted solution]

Hi @EdsonGomes ,

Paste this into a new blank query to see the steps I took:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjRS0lEKLE3MUShOLVXIy89NtQcKuJXmJOblGyrF6kBVFJcmKmSmJKakAtnGpqjiyTCJIC+EBA4jjbAbaWSMw8jgAIiEMW4jjREqsLnSGN1IX3el2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [id = _t, pregunta = _t, resposta = _t]),
    chgTypes = Table.TransformColumnTypes(Source,{{"id", Int64.Type}, {"pregunta", type text}, {"resposta", type text}}),
    addNomeColumn = Table.AddColumn(chgTypes, "nome", each if [pregunta] = "Qual seu nome?" then [resposta] else null),
    fillDownNomeColumn = Table.FillDown(addNomeColumn,{"nome"}),
    pivotPreguntaColumn = Table.Pivot(fillDownNomeColumn, List.Distinct(fillDownNomeColumn[pregunta]), "pregunta", "resposta")
in
    pivotPreguntaColumn

This give the following output:

Pete