I have a SPILL formula -- TRANSPOSE(W3#) -- that transposes a vertical column of values from this:
1
2
3
4
To this:
1 2 3 4
When it's done, I'd like it to automatically add another value after the last spilled value like this:
1 2 3 4 OVERALL
My source is dynamic, so sometimes it ends at 4, while other times it can end on 7, 10, or whatever. But either way, I want to add "OVERALL" right after the last value.
Is there a way to do this in the formula?
1
2
3
4
To this:
1 2 3 4
When it's done, I'd like it to automatically add another value after the last spilled value like this:
1 2 3 4 OVERALL
My source is dynamic, so sometimes it ends at 4, while other times it can end on 7, 10, or whatever. But either way, I want to add "OVERALL" right after the last value.
Is there a way to do this in the formula?