I need to take some data hourly from table

[clayman]

I have a big excel table this table formed minute to minute. It start 02.06.2006 and it finish 01.01.2007. And i must take data hourly from this table.

Like this;

Original Table My Table
Date Time X Date Time X
------------------------------------------------------------------------
02/06/2006 00:00 35,42 02/06/2006 00:00 35,42
02/06/2006 00:01 28,25 02/06/2006 01:00 .......
02/06/2006 00:02 19,61 02/06/2006 02:00 .......
02/06/2006 00:03 10,69 02/06/2006 03:00 .......
02/06/2006 00:04 3,12 02/06/2006 04:00 ......
02/06/2006 00:05 358,15 02/06/2006 05:00 ......
02/06/2006 00:06 0,30 ................ ........ ......
02/06/2006 00:07 357,29 ................ ........ ......
02/06/2006 00:08 353,81

I attached the part of table because my original table is too big to attached here. If you look it you will understand more easy.

I need help. Please help me

[DonkeyOte]

You have a few choices...

Most obvious -- use a Pivot Table -- see attached:

[clayman]

thank you vey much. I try it.

[clayman]

Pivot table dont solve my problem. Can anybody look this example and give me an advise for this problem.

My date dont continuously, some date unavaliable in original table. But i must that date and X data ( sure X data will be empty )

For that reason pivot table cant solve my problem. I need macro or formula.

Date must start first date in original table and must finish last date in original table. And all days must be in the my table.

Please help me.

[DonkeyOte]

Not sure I understand -- the PT as was did show by day & hour correct ?
If you wanted to show minutes (grouped by hours etc) click on the Time header and choose option "Select All"

As for generating the PT --> very straightforward (note instructions for 2007 vn)

Highlight your data -> Sheet1 A2:C4256

On Ribbon -> Insert -> Pivot Table

If you have selected your range it will automatically be highlighted

Click OK

Drag DATE & TIME to ROW LABELS box
(time should go below Date)

Drag X to VALUES box

On the resulting PT:

To Group by Year, Month & Day...
Right Click on a Date Value and select Group -> select Years, Months, Days

To Group by Hours, Minutes...
Right Click on a Time Value and select Group -> select Hours, Minutes

To get the PT to look a little more tabular...

Ribbon -> Design -> Report Layout -> Tabular Form

[DonkeyOte]

Clayman, if the solution provided does not meet your requirements please post reasons etc to your post directly as opposed to PM'ing other members on the thread (ie me ;-)) -- I ask this for two reasons - firstly other people may have similar issues in future (and so your thread may help them resolve their own issues) and secondly there are other members who can assist you other than me and by mailing me directly as opposed to posting to your own thread you lose the chance of an alternative solution.

Thanks

[clayman]

I write here ( but i edit my older post for that reason i think you will not see my edit ). Ok i copy my older post again. Thanks.

Pivot table dont solve my problem. Can anybody look this example and give me an advise for this problem.

My date dont continuously, some date unavaliable in original table. But i must that date and X data ( sure X data will be empty )

For that reason pivot table cant solve my problem. I need macro or formula.

Date must start first date in original table and must finish last date in original table. And all days must be in the my table.

Please help me.

[stanleydgromjr]

clayman,

Received your Private Message.

I have examined your workbook. I have an idea for a solution, but I need some questions answered.

How is the data in the "Original Table" being created?

Are we going to create the "My Table" from the "Original Table?

Does the original data come in where each date has a row for each of the 1400 rows, from 0.00 to 23.59?

Can you post another workbook/worksheet with the way the original data comes in, without any updates/changes by you?


Have a great day,
Stan