Hello,
I am having difficulty transposing data that is recorded in irregular time intervals into a separate sheet which puts the data into 1-min or 5-min intervals. The data represents the time that a piece of machinery turns "on" or "off", designated by a "1" or "0" respectively.
For example, the data I have looks like:
A B C
Date Time On/Off
1/12 12:00:00 1
1/12 12:03:00 0
1/12 12:07:00 1
And I need to change it into:
A B C
Date Time On/Off
1/12 12:00:00 1
1/12 12:01:00 1
1/12 12:02:00 1
1/12 12:03:00 0
1/12 12:04:00 0
1/12 12:05:00 0
1/12 12:06:00 0
1/12 12:07:00 1
etc.
I'm not sure if a Macro is needed for this application, or if there is another excel trick to perform this task. Any help will be appreciated, thank you.
Bookmarks