I have two sets of data which i wish to link together, the problem is that they come in different formats and I wish to map them together.
one set creates a display as follows:
APP
1.1
1.2
1.3
a
01/02/2008
01/02/2008
01/02/2008
b
02/02/2008
03/02/2008
04/02/2008
c
03/08/2009
03/08/2009
03/08/2009
In this view each column is a field, ie App, 1.1, 1.2, 1.3
In the second set of data we have the following:
APP
Question
Date
a
1.1
01/02/2008
a
1.2
01/02/2008
a
1.3
01/02/2008
b
1.1
02/02/2008
b
1.2
02/02/2008
b
1.3
02/02/2008
c
1.1
03/08/2009
c
1.2
03/08/2009
c
1.3
03/08/2009
So in this there are only 3 fields. This is the representation we want to have so we can have all the questions as one field. Is there a way through mapping we can change the initial data to the second format?
