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
Bookmarks