I have data in my spreadsheet in a worksheet like this:
Where the data goes in this format
[ID] | [Date] | [Hour] |
And I have another worksheet where I want the data to be like this:
Where I want the data displayed to be like:
[DateRange's First ID + " - " + DateRange's Last ID] | [DateRange's First ID + " - " + DateRange's Last ID] | [Date]
How could I make this using formulas or VBA macros?