I created in table1 a list of persons, one person per row : in A1 Max, in A2 Tom and in A3 Georg. In table2 I want align the persons in columns. I wrote in table2 in cell B1
=table1.A1
an in C1
=table1.A2
I marked both and dragged to the right. In cell D1 now appears
table1.C4
but I liked to have
=table1.A3
=table1.C1
appears in cell D1, nottable1.D4
.