+ Reply to Thread
Results 1 to 3 of 3

select relevant data and transpose

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Cardiff
    MS-Off Ver
    2003
    Posts
    123

    select relevant data and transpose

    I have to sort data every so often and the manner in which i download it isn't very useful. It would be much more useful and muc much easier to read if the data were set out in a completely different way.

    How can i organise the data so that it will create a sheet that has the column headers of: site name, date, det1, det2, det3 (etc for all dets, over 100)

    and under each column to have the site name with the relating date and data for each of the dets relating to that date and site. It would be useful to only get one row of data for each date for that particular site, so that you can view all of the data for that entry in one go.

    I have attatched a sample spreadsheet with only a few sites, there a re normally around 300 sites (each with over 100 dets)

    I am using office 2003
    Attached Files Attached Files

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: select relevant data and transpose

    I'm not sure what your data is but maybe use a PivotTable
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Cardiff
    MS-Off Ver
    2003
    Posts
    123

    Re: select relevant data and transpose

    I pivot table would be nice to view the data, but this data needs to be added to another spreadsheet where data for the last few years is kept.

    So this has to be done fairly frequently.

    Do you think it is possible to re-arrange the data in a macro so that there is only 1 row for each site and date?

    I had help earlier on how to get the correct result using formlua (http://www.excelforum.com/excel-gene...nd-filter.html), but this would be time consuming for the future, wondered if I could use a macro as once made it could be used everytime data is downloaded.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1