Formula, take 1 row/column and creating more rows that subtract 1 till desired

Question

Hi,

Say I have the value of:

Period Remaining

78

and I want to create:

Period Remaning                     7877767574737271706968676665646362616059585756555453525150494847464544434241403938373635343332313029282726252423222120191817161514131211109876543210-1-2-3-4-5-6-7-8-9-10-11-12-13-14-15-16

for 95 rows.

Is this possible to do?

Thanks.

chuckleswk · Accepted Answer

Yes, you can use the Generate Rows tool to do this: