Adding row in query from different table

[kivanct]

Hi,

These 2 products located in LSF table.

I woud like to add these rows into ZD83 table.

But these 2 products (in LSF) have no correspondant in ZD83 table. Even column names are different. How I can add these 2 products into ZD83 table  ? Is it possible ? Or how i can create matrix of ZD83 which also includes these 2 products(in LSF) ?



Regards

[Mahesh0016 · Accepted solution]

@kivanct ,

>> Go TO Power Query >> Select ZD83 table >> Go to Home tab Append Queries >> Append Queries As New Or Append Querie As per your needs.

**If this post helps, please consider accept as solution to help other members find it more quickly.

[kivanct]

Thanks a lot, I managed to do it.