Help required to do excel reformatting

Hi,

I need help to do reformatting in excel.
Attached one spread sheet for the sample input and expected output. File name is Example file.xlsx
Can you provide your suggestions, how to get the expected output?
This is sample file. Actual file contains around 25K records.
Appreciate your help.

Thanks and Regards,
Pal.

1 of the possibilities

Please Login or Register  to view this content.

Kind regards
Leo

This solution takes only the first year in the range and outputting.
I need rows to be repeated if there is an year range.
Kindly check the sample spread sheet attached in the original thread

Yes i see, so it has to be more like this


Kind regards
Leo

Hi,

Tested it with some more records. It works fine. Thanks a lot. Appreciate your timely help.

Regards,
Pal.