Result of Choosecols function to overlap to next parallel cells

[ExcelNewbie2020]

Sirs,

is it possible that the result of an array formula overlap to the parallel cells?..basically same format as the source data.
please see screenshot.. using a formula i was able to get the value i expected.. however, i need to adjust the column width for each value (the value on my actual data overlap up to column D).

 

[StephenCrump]

You'll need to adjust the column widths. An Excel formula can't do this.

For example, use Copy/Paste Special (column widths) to copy column widths for A:C to J:L

Or do the same using VBA code.