To build the report in VBA excel

[motherindia]

Hello Sir, I have sheet1 with 5 columns as shared below. ColumN A contains single data or multiple data for same id . Column B contains start month and C contains End month ie 1 to 12 (Jan to Dec, 1 for Jan, 2 for Feb.....,12 for Dec). Column D contains cost amount and Colum E contains Status. I need to convert the data of sheet1 as per sheet 2 format . Regards, motherindia Sheet1

Unique ID

From

To

Cost

Status

10001​

1​

3​

1000​

Cleared

10001​

4​

5​

1200​

Pending

10001​

6​

9​

1300​

Pending

10001​

10​

12​

1400​

Cleared

Sheet2 -output

Cost

Status

Unique ID

1​

2​

3​

4​

5​

6​

7​

8​

9​

10​

11​

12​

1​

2​

3​

4​

5​

6​

7​

8​

9​

10​

11​

12​

10001​

1000​

1000​

1000​

1200​

1200​

1300​

1300​

1300​

1300​

1400​

1400​

1400​

Cleared

Cleared

Cleared

Pending

Pending

Cleared

Cleared

Cleared

Cleared

Pending

Pending

Pending

 

[Rijnsent]

Hi motherindia,
what did you try so far? Any code you can share?
Thanks,
Koen
P.S. Please preview your post next time, this big table looks horrible with your question in the first cell.