I have a list which contains simple and calculated columns.

I want to copy the data from one list to another list.

What are the opions of bulk copying the contents from one list to another.

The OOB is my first priority.

1. Use Content and Structure to move the whole List somewhere else in the Site Collection.

2. Save the list as template including content and re-create it in the new site using the same template, again same site collection.

3. If you already have the columns created in the new list, copy the data from the datasheet view. Copy the calculations to the new calculated columns and they would work once you paste the data over.

Hope it helps.

I have dissimilar columns but they are not mandatory as there are two lists.

The new list is a union  of the two lists with some extra columns So, i need to find out a way to copy paste the contents of the two lists to the new list.

I have dissimilar columns but they are not mandatory as there are two lists.

The new list is a union  of the two lists with some extra columns So, i need to find out a way to copy paste the contents of the two lists to the new list.