Pivot Table or Dynamic number of columns in a grid(like Excel) in JDE 8.12 TR 8.96.40

Is it possible to generate dynamic number of columns in a grid ?

For example, I have an Excel sheet with number of columns. It is related with Cash Management. If the end user plan to settle all suppliers within 10 months, and if the total is $10000. My gird will have 10 columns(from Month 1 to Month 10), and each column will have $10000/10 = $1000.

If the user plan to pay the amount by 24 months, my grid need to have 24 columns.

As we know, it is very easy in a spread sheet application. But how can we implement it in JDE ?

One possible way is to have grid a maximum number of columns (say 100) and then disable unwanted columns. But it is not a good idea, if the user want to have only 9 column, I want to hide 91 columns