AnsweredAssumed Answered

Pulling data from several sources into one dataset

Question asked by sphilipr on Apr 10, 2015
Latest reply on Apr 12, 2015 by erolst

I have three separate lists of data for example; one bank account and two credit cards, that I want to combine into one list without merging the three original sources which must stay separate and not be modified. I want the final data to be available in a list of the same set of 4 fields (Date, description, amount and type).

It seems as though it must be elementary but a lookup would only pull form any one of the three and a calculation seems the obvious choice but I have now idea which function would perform the merge. Any assistance with this basic problem would be very much appreciated.