SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

As the title says I want to merge some lists with the same columns together and then add a new column with the name of the list this item was extracted from. Is it possible to do this out of the box (with SharePoint online)? If it's not possible I'd create a new empty merged list and a workflow for the content lists, which just writes changes in the merged list. Here's an example of what I want to do:



item1 List1
item2 List1
item3 List2
item4 List2
share|improve this question
why do you want to do this ? If they have the same columns, you can create a single list with a Choice field which tells the Category of the Item... just a thought! – Arsalan Adam Khatri Dec 5 '12 at 13:39
The lists are project tasklists from different departments. This lists are synchronised with outlook, which doesn't allow custom columns. – Aljoscha Husp Dec 5 '12 at 14:02

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.