Turn off spill in dynamic arrays

[DrDebit]

If I have filled cells in A1:A4, and in cell C1, I have =A1:A4, it spills down. To turn the spill off, I insert an @: in cell C1: =@A1:A4. Now all the values will be in cell C1, with no spilling. Perfect!!
However, If I have filled cells in A1:B4, and in cell C1, I have =A1:B4, it spills down and across. To turn the spill off, I insert an @: in cell C1: =@A1:B4, and I get a #VALUE! error. What am I doing wrong? Can I fix this multiple-column spill and turn the spill off? Thank you in advance!

 

[JEC]

Use an INDEX function to specify your row and column

 

[DrDebit]

Thank you!
David

 

[Peter_SSs]

If I have filled cells in A1:B4, and in cell C1, I have =A1:B4, it spills down and across. To turn the spill off, I insert an @: in cell C1: =@A1:B4

If you just want that same row from the original data, why use =A1:B4 in the first place then try to fix it with @ (or INDEX)? Why not just =A1:B1 ?