Hi All,

I'm new to Macros and below is my requirement.I need to split my data into multiple rows based on count
and the first row should have the value but the other rows should have a value as zero

Input

Count Value
1 400
2 101
3 300
4 450

Output

Count Value
1 400
2 101
2 0
3 300
3 0
3 0
4 450
4 0
4 0
4 0

Any advise

Thanks in advance