SharePoint List report / Overview

Copper Contributor

Hi, I want to know if there's a way to bring all the list on a site into one summary overview or even into a Array and display only the item contents. For Example, If I have 3 List. Each of these list have different column except the Title and The Assigned To columns. Then pulling all three list together and then display only the column that are the same into one List. 

 

Is this a possibility? The reason I ask is because the users work and collaborate with multiple department. Which on each department site has their own list of things to do. I understand that you can't pull from multiple sites but can you do it from single site for multiple list.

0 Replies