I'm curious as to how I would bulk import items on to an existing SharePoint list (if it is possible). I understand you can create a new SharePoint list from an excel spreadsheet but that does not answer my question... see below.
First, lets assume a few things:
1) This data is coming from two different SharePoint lists
2) The data is formatted the same, so although columns may not be named the same the data types of those columns are the same (text box = text box, look up = look up, etc)
3) Lets call the first two lists: List 1 and List 2 and then the merged list we will call Merged List.
4) I am using SharePoint Designer 2013
I tried to export List 1 as a template and then build the first half of Merged List, which "works" sort of but I have to manually add all the items from List 2 in to the Merged List. Which again, sort of works but right now this is test data of 5 records, obviously this will not be feasible with hundreds of records.
I have also tried to look at these solutions: sol1, sol2, sol3. Sol3 has three different types of solutions that overlap with the first two however it also has two other solutions on the page that are interesting but don't quite fit my problem.
Note: This could simple just not be possible, which is also an acceptable answer. I just either need a solution to my problem or a clarification that this is not a possible task (excluding the attempts I have already done).