It's my first time trying to use this function and when I try to create a
simply one like ={1,2,3,4;5,6,7,8} and Ctrl + Shift + Enter. The only thing I
have is on the to rows, in the first column 1, on the second one 2, on the
third one 3 and at least 4 on the last one. But I should have 1234 on the
first row and 5678 on the second row.
I don't understand, what is going wrong?

Please help. I'm using excel 2003