Reduce Rows with Data

[Vixx1]

Hello,
I've got problem with excel task. I need to compress rows for specific ID number ( its like 50k record). For 1 spec ID for now its 12 rows and I'd like to insert all this data to 1 row, for now i don't know how to solve this, please help me

[Kaper]

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?

[Kaper]

Don't know why you cannot answer in the thread (as you reported in PM), but the solution could be such code:

Please Login or Register  to view this content.

See also attached file