Pivot - Several lines for the same pivot.

Hi jcmartin01 ,

Select 'Don't' Aggregate' in the advanced options. The error will disappear.

Testing M codes:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIwNzU0UdJRioiIAJJGBoYGuoaGuhZKsTpQSVNkSUNdE12gCC5JC11jA4SkGaqkJVhnLAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [QMNUM = _t, MNCOD = _t, ERLDAT = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"QMNUM", Int64.Type}, {"MNCOD", type text}, {"ERLDAT", type date}}),
    #"Pivoted Column" = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[MNCOD]), "MNCOD", "QMNUM")
in
    #"Pivoted Column"

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.