If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel Query

PGL · 2013-01-02 22:11:55

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…

02-01-2013 10:11pm

#1

PGL

Registered Users, Registered Users 2 Posts: 762 ✭✭✭

Join Date: September 2006

Posts: 567

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!

0