Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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:

List1:
item1
item2

List2:
item3
item4

MergedList:
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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.