0

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
2
  • Add images and format text better. Show us your effort. Jul 1, 2017 at 22:05
  • I followed the steps you described, and =table1.C1 appears in cell D1, not table1.D4.
    – Jim K
    Jul 2, 2017 at 5:33

1 Answer 1

0

To use a formula, set table2.B1 to:

=INDIRECT("table1.A"&COLUMN()-1)

Then drag the formula to D1, which now shows Georg. For documentation, see INDIRECT and COLUMN.

Alternatively, transpose the data by copying and pasting special, described in https://help.libreoffice.org/Calc/Rotating_Tables_Transposing.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .