Process PDF data in just one line.

Hi gabrielrosa  

please paste the code into the advanced editor and follow the code:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXLLTM1JATEMDZRidZDEjIAMIzQxYyDDGCJmhKzXBE0MxDBFEwPpNQOKxQIA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t, Column3 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}, {"Column2", type text}, {"Column3", Int64.Type}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Column1"}, {{"Partition", each _, type table [Column1=number, Column2=text, Column3=number]}}),
    #"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.FromRows({[Partition][Column3]}, [Partition][Column2])),
    #"Expanded Custom" = Table.ExpandTableColumn(#"Added Custom", "Custom", {"Field1", "Field2", "Field3"}, {"Field1", "Field2", "Field3"}),
    #"Removed Other Columns" = Table.SelectColumns(#"Expanded Custom",{"Partition"})
in
    #"Removed Other Columns"