How do I merge multiple Sharepoint list into one list

[vjeshwar]

Is there a way I can merge multiple sharepoint list into one common list wherein the updates that I do gets reflected everywhere,

[mahoneypat · Accepted solution]

You can append individual queries to do that, but if you have multiple lists with the same structure on different sites, you can create a table that has 3 columns - the tentant url, site name, and list name, and pass those into a custom column in which you invoke the function share in this article/video.  You can then expand that column of "Table"s to get your combined data.

Get Data From SharePoint Lists … But Fast – Hoosier BI

Pat

[Greg_Deckler]

@vjeshwar An Append query?