I'm trying to bring the A value down into all the rows, then B, and then so on. The ungroup function doesn't work (the data was exported from Tableau) and there's way too many locations to do it manually. Is there a function that I can use to achieve this? I thought of grabbing the first value and then making the others zero and then implementing a function from there, but I'm getting stuck on how I'd do it.

A better illustration of what I'm trying to do: