Generate Rows

[lbrehmer]

Hoping for assistance on a formula to generate additional rows to align all TBC columns and their multiplier as seen in the attached excel examples.

Starting Data

Desired Outcome

[DavidP · Accepted solution]

Here's one way of doing it

[lbrehmer]

Thank you very much for the quick reply!