Hi guys,
I'm trying to manipulate some data for my thesis and I've been trying for hours but cannot figure this out, so any help would be much much appreciated.
Here's the prob:
Currently the data is in the following format:
A B C
1 Fund Date MER
2 22 31/10/1990 2
3 22 31/12/1990 3
4 33 28/02/1991 1
5 56 31/11/1990 0.1
6 56 28/02/1991 1
So each fund has several different entries in the final two columns based on varying dates.
But I want the data transformed so that I have the dates in row 1 and funds in column 1. And the MER value to be the match of the two. BUT I also need the dates to find their spot in the columns- so that it should look like this.
A B C D E F
1 Fund/Date 31/10/1990 31/11/1990 31/12/1990 31/01/1991 28/02/1991
2 22 2 3
3 33 1
4 56 0.1 1
I desperately need this, so all you Excel gurus, please help!
Thanks
miss*m