Hello, I have two sets of data organized in a table. For example:
Set 1:
DATE CUSTOMER LOCATION
Set 2:
DATE STORE TIME
I would like to combine these two data sets into one pivotable. How can I combine two data sets in one table? I am most concerned with matching the data in set 1 with set 2 by date of occurence. Is a pivotable the best way to do this? Also, if it matters, there is a large amount of data in each cell (like a paragraph). Just wanted to mention that in case it alters the suggestions (I want to be able to print out the pivotable). Thanks.
Set 1:
DATE CUSTOMER LOCATION
Set 2:
DATE STORE TIME
I would like to combine these two data sets into one pivotable. How can I combine two data sets in one table? I am most concerned with matching the data in set 1 with set 2 by date of occurence. Is a pivotable the best way to do this? Also, if it matters, there is a large amount of data in each cell (like a paragraph). Just wanted to mention that in case it alters the suggestions (I want to be able to print out the pivotable). Thanks.