Dear All,
Greetings! Its wonderful to be connected to this forum. I'm struggling with this question and have looked at various threads before posting here. I will demonstrate with an example to make it clearer for you kind folks:
Current data:
Date: Unique code Value
date 1 x 0.2
date 2 x 0.1
date 3 x 0.67
....... x 0.23
....... x 0.34
...... x 0.19
date N x 0.29
date 1 y 1.03
date 2 y -0.32
date 3 y 0
....... y 2.3
....... y -
...... y -
date N y 2.007
date 1 z 0.98
date 2 z 1
date 3 z 2
....... z -0.99
....... z 1.1
...... z 4
date N z 0.89
What I want is:
Date: Unique code x's value Unique code y's value Unique code z's value
date 1 0.2 1.03 0.98
date 2 0.1 -0.32 so
date 3 0.67 so on on
........ so
........ on
........
date N 0.29 2.007 0.89
As you guys can see the dates are same for each code. Please let me know if there is a way/formula to do this. Thanks a lot in advance!
Bookmarks