Hi to everybody!

I am using LibO 7.0.2.2 using the package from Lubuntu 20.10 repository.

I have one book with four sheets. The first two have records with 50 columns each. The fist one have 1035 records; the second, 420. The third sheet has the range addressess for each column range in each sheet. I used a vertical layout to have this data:

```
sheet name | range address | merge of sheet and address | column name
------------------------------------------------------------------------------
sheet 1 | a3:a1038 | 'sheet 1'.A3:A1038 | temporalmark1
sheet 1 | b3:b1038 | 'sheet 1'.B3:B1038 | disability type
...
sheet 1 | ah3:ah1038 | 'sheet 1'.AH3:AH1038 | disease
sheet 2 | ax3:ax423 | 'sheet 2'.AX3:AX1038 | temporalmark2
sheet 2 | aj3:aj423 | 'sheet 2'.AJ3:AJ423 | disability type
...
sheet 2 | m3:ah423 | 'sheet 1'.AH3:AH423 | disease
```

I am creating a fourth sheet where I merge the ranges, column by column. As you can see, the columns ranges do not match columns for each question (column name): temporalmark1 in sheet 1 is in column A and temporalmark2 in sheet 2 is in column AX.

Since I am unable to make `DDE`

function to work in my local Linux computer, I am using matrix formula with INDIRECT function, pointing to a cell where I wrote the range address for each column. Besides, I’m not sure if `DDE`

is my solution…

What I am doing is manually pasting for each range the matrix formula (in a vertical layout). For the first range/question temporalmark1, for example, I select (in sheet 4) 1035 cells, then apply `{=INDIRECT("'sheet 3'.B2")}`

, assuming the above table starts in A1 in sheet 3 and the addresses are in column B…

```
temporalmark | disability type | disease
--------------------------------------------------
data1/sheet 1 | data1/sheet 1 | data1/sheet 1
data2/sheet 1 | data2/sheet 1 | data2/sheet 1
...
data1035/sheet 1 | data1035/sheet 1 | data1035/sheet 1
data1/sheet 2 | data1/sheet 2 | data1/sheet 2
data2/sheet 2 | data2/sheet 2 | data2/sheet 2
...
data420/sheet 2 | data420/sheet 2 | data420/sheet 2
```

This is a painful method because I have 100 questions (50 in each data sheet).

**I ask if there is a better method to merge cell ranges, as dragging the matrix formula?****Or if the**`DDE`

function might help (I cannot make it to work even though I am using a single Calc book)?

I might be convoluting and overcomplicating the solution, but I am unable to do it other way than manually

Any best practice or tip would be VERY MUCH appreciated!

(here is an example of what I am trying to accomplish)

cell-ranges.ods