I've attached a workbook with three tabs.
The original data (shown on one tab) has three columns: Date, Value, and Day of Week
I need to convert this data into a new format, where every date is converted to a style which is not available in the format settings (even the custom settings). For every single date in the original data, I need to divide it into 24 individual timestamps in the format shown in the Desired Outcome Tab.
The only way I could create this desired outcome, was to treat the date like text, with a space at the beginning so that Excel wouldn't think that its a formula. Then concatate that date with a series of 24 times, as shown in the desired outcome.
I've got 5 years of data to convert into this new scheme.
Any ideas on how to do it with formulas? (ultimately, the revised data will be output to a csv file)
Thanks!
Bookmarks