Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel Query

  • 02-01-2013 11:08PM
    #1
    PGL
    Registered Users, Registered Users 2 Posts: 762 ✭✭✭


    Hi folks

    I have an excel problem which I'm hoping someone can put me straight on.

    See attached spreadsheet. "Sheet 1" contains raw data which I have downloaded from another source. I want to find a way to automatically have the data re-arranged as per "Sheet 2".

    The reason I want to find a way / formula / macro to automatically do this is because I am downloading huge amounts of data on a regular basis. e.g. this sample data is based on one day for three generators - I will generally be downloading data on a monthly / yearly basis for lots of generators. Hence - a lot of data!

    I have trawled the net in order to find a soluton, but to no avail. Some help / advice would be great.

    Thanks in advance!


Comments

  • #2
    chavezychavez
    Registered Users, Registered Users 2 Posts: 963 ✭✭✭chavezychavez


    Could you try run a pivot table with "Generator" in columns, the 3 delivery fields in the rows and the MSQ Summed as Data.

    This will output the data in a very similar manner to what your Sheet 2 is like.


  • #3
    PGL
    Registered Users, Registered Users 2 Posts: 762 ✭✭✭PGL


    chavezychavez wrote: »
    Could you try run a pivot table with "Generator" in columns, the 3 delivery fields in the rows and the MSQ Summed as Data.

    This will output the data in a very similar manner to what your Sheet 2 is like.

    Hi chavezychavez.

    Thanks for your response. I have had a quick look at pivot tables and it looks like it could be the way to go for me. I know nothing about pivot tables, so I'll have to delve deeper to see if it will completely solve my problem - will update you when I do!


  • #4
    PGL
    Registered Users, Registered Users 2 Posts: 762 ✭✭✭PGL


    PGL wrote: »
    Hi chavezychavez.

    Thanks for your response. I have had a quick look at pivot tables and it looks like it could be the way to go for me. I know nothing about pivot tables, so I'll have to delve deeper to see if it will completely solve my problem - will update you when I do!

    Pivot tables is the solution to my problem!

    Many thanks for all the responses.


Advertisement