Iterative help

[WestonProhaska]

Hey

I'm having trouble on an iterative macro

Essentially, I have data like below:

2014	2015	2016	Start %	End %	Increment	Adjustment
.4	.4	.4	.4	.2	.05	A
,4	.4	.4	.4	.15	.05	B

1. Is it possible to configure my macro to get me an output similar to something like below? 

-I want to add the previously completed iteration conditions to the ones  that continue onwards after finishing the condition. 

Results of current iterative macro:                                                                                   

2014	2015	2016	Start %	End %	Increment	Adjustment	Scenario
.35	.4	.4	.4	.2	.05	A	1
,35	.4	.4	.4	.15	.05	B	1
.3	.4	.4	.4	.2	.05	A	1
.3	.4	.4	.4	.15	.05	B	1
.25	.4	.4	.4	.2	.05	A	1
.25	.4	.4	.4	.15	.05	B	1
.2	.4	.4	.4	.2	.05	A	1
.2	.4	.4	.4	.15	.05	B	1
.15	.4	.4	.4	.15	.05	B	1

Results I'm looking for:

2014	2015	2016	Start %	End %	Increment	Adjustment	Scenario
.35	.4	.4	.4	.2	.05	A	1
,35	.4	.4	.4	.15	.05	B	1
.3	.4	.4	.4	.2	.05	A	1
.3	.4	.4	.4	.15	.05	B	1
.25	.4	.4	.4	.2	.05	A	1
.25	.4	.4	.4	.15	.05	B	1
.2	.4	.4	.4	.2	.05	A	1
.2	.4	.4	.4	.15	.05	B	1
.2	.4	.4	.4	.2	.05	A	1
.15	.4	.4	.4	.15	.05	B	1

Thanks!

[ArtApa]

Hi @WestonProhaska - Attached is a solution without Macro. I made it dynamic for you: