is expected output one very long row for each ID?
It wil be a) very tough to read b) even tougher to process

3 additional questions:
- will there be always 12 rows for each ID? or could it change - some ID's with less, or may be some with more rows?
- will start and end dates (columns B and C) have the same values within single ID?
- why do you put texts just looking as dates, not real excel dates in column B?