Splitting row as another row by sequentially

Hi Vinothsusai ,

We can implement it in Query Editor.  You can try the following steps.

1. append the Vendor table and Customer table 
2. create a new column to combine the Vendor Amount column and Customer Amount column.
3. remove the two Amount column.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Tcu7DsMgDEDRX6mYM5hAXmMUqVKHrllQhohm6ICpIjr074tT18EL13BwTk0xvFb8qErd1yem0fv4xpTXG6Zt9zHMGz7ift7/9ssYjn2pnLoC9PlB09DHaQYAqiGffzHkvaYRQdWfQgMLI4KqK4RmYUVQtYWoWTQiqJpCGBatCCpbCMuiE0FlDrF8AQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [#"(blank)" = _t, #"(blank).1" = _t, #"(blank).2" = _t, #"(blank).3" = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"(blank)", type text}, {"(blank).1", type text}, {"(blank).2", type text}, {"(blank).3", type text}}),
    #"Promoted Headers" = Table.PromoteHeaders(#"Changed Type", [PromoteAllScalars=true]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Promoted Headers",{{"Company", type text}, {"MaintAccount", Int64.Type}, {"IntercomVendorAccount", type text}, {"Vendor Amount", Int64.Type}}),
    #"Appended Query" = Table.Combine({#"Changed Type1", Customer}),
    #"Added Custom" = Table.AddColumn(#"Appended Query", "Custom", each if [Customer Amount] = null then [Vendor Amount] else [Customer Amount]),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Vendor Amount", "Customer Amount"}),
    #"Sorted Rows" = Table.Sort(#"Removed Columns",{{"MaintAccount", Order.Ascending}})
in
    #"Sorted Rows"

I attached my sample that  you can download.

 

Best Regards,

Xue Ding

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