Can You Store An Array of Values In A Single Cell Based on Values Of Other Cells?

Hi Sunday workers, Is it possible to store an array of values in a single cell based on the values of other cells using the application Excel (not vba).

E.g. 1.jpg

In cell E2 I want to store A1+1 as a value & A1+2 as a value; E2={A1+1,A1+2}. I do not want the sum (as I'll be using these values in other ways later). I just want to store an array of values and access these values by their subscript #'s/ index #'s.

Research suggests arrays are only relevant in vba really. Array formulas are for when data is arranged in a tidy manner, not really for where data is all over the place and needs gathering.
I think I'm going to need to concatenate values & display them in a single cell. Then split them values for processing/ calculations where & when they are needed.