Desperate!-covert data in columns to rows and columns with intersection values

  • 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

  • Re: Desperate!-covert data in columns to rows and columns with intersection values


    Have you tried a pivot table?

    [SIZE=2]I should change my name to STUMBED![/SIZE]

  • Re: Desperate!-covert data in columns to rows and columns with intersection values


    Chris,


    You are GOD!! :rock:
    I've just learnt how to use Pivot tables for the 1st time!


    :thanx: miss*m

  • Re: Desperate!-covert data in columns to rows and columns with intersection values


    Not a God I just figured them out a couble of months ago and now they're my answer to evrything. So have fun! :guitar:

    [SIZE=2]I should change my name to STUMBED![/SIZE]

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!