For example: C4=5,C5=18, and C6=7.
I want A1 to show 4,5,18,7 (the values of cells C4 to C6).

I believe I have done this before, about 10+ years ago.

Bruce