Shares1, Shares2, Shares3, Shares4... all the way up to Shares60.

 

Each "Shares#" field is tied to a vesting date.

 

Instead of inserting 60 rows of details (one for each Shares# field), I'm hoping I can create a single formula field that will automatically insert rows if the share value is greater than 0 for the next Shares field.

 

For example. If Person #1 has Shares1 = 100, Shares2 = 50 and Shares3 = 0 then I want it to look like this.

 

Person 1    100

Person 1    50

 

I will need to do that same thing for the vest date.

 

Does this make sense?