In the following, I describe how to show content from two lists in the same view.
Lists names are “SharePoint 1” and “SharePoint 2”.
SharePoint 1 list is a custom list with Title column:
SharePoint 2 list has same columns as SharePoint 1 List:
Open the SharePoint Designer 2013 and Open the site where you have created the lists.
Click on “Data Sources” in left and then click on “Linked Data Source”
Then click on Configure Linked Source…
Select our lists in the Wizard and click next.
Chose the “Merge” option, so we can sort and filter the content as one long list:
Our data source is created.
After that create a new “Web Part Page”. I already created and named demo.aspx.
Edit the page in designer
Then click on “Insert” tab in the ribbon, and selected Data View button. You will find “Linked Data Source” in dropdown list under “Linked Source”.
Click “Add/Remove Columns” on top:
You can add or remove columns here. Removed “Modified” column:
Search the “row view” in code for Data View web part. “Row view” contains XSLT that is used to display items:
Added “disable-output-escaping “to above. Setting “disable-output-escaping” to “yes” make the column to render as HTML and not as text.
Then click on “Sort & Group” in the ribbon. It is for sorting on a columns or columns. I sorted the view by Title column:
Then click on “Web Part” in the ribbon and select “To Site Gallery”:
Data View with two lists as data source is saved as web part on the site now. Now open the page. The web part looks like this: