1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Windows Today's Excel question

Discussion in 'Software' started by Shirty, 8 May 2015.

  1. Shirty

    Shirty W*nker! Super Moderator

    Joined:
    18 Apr 1982
    Posts:
    12,474
    Likes Received:
    1,694
    I have a list of data, and I want to do some sort of lookup based transpose, so I can populate columns with the correct photo file names.

    Basically, the data is currently sorted as per columns A & B on the shot below, and I need to get it into the format of D, E, F, G, H and so on:

    [​IMG]

    It is more complex than meets the eye, but I'm sure it's achievable. We have tens of thousands to sort out ;)

    Any ideas?
     
  2. David

    David Take my advice — I’m not using it.

    Joined:
    7 Apr 2009
    Posts:
    14,782
    Likes Received:
    3,230
    So, you want to group and transpose?

    Is this the kind of thing you want?
     
  3. Shirty

    Shirty W*nker! Super Moderator

    Joined:
    18 Apr 1982
    Posts:
    12,474
    Likes Received:
    1,694
    Cheers Dave, it wasn't quite right but I was able to bodge the data and macro a bit to make it do as it was told :D
     
  4. megamale

    megamale Member

    Joined:
    8 Aug 2011
    Posts:
    252
    Likes Received:
    3
    I would use a pivot table. It wouldn't come exactly as you want, but at least it will put in a format where it should be easier to manage.
     

Share This Page