Put named range verticle

Put named range verticle

Problem Description:

I have a named range (Sheet1!B1:Z7), that I want to place on another sheet placed verticle. Now I do this manually through:

=UNIQUE({Categorie!B:B;Categorie!C:C;Categorie!D:D;Categorie!E:E;Categorie!F:F})

But I would like to use the named range

=UNIQUE({Categorieen})

But that does not work.

I want to stack all the columns verticle

Is this possible? I could not find examples using named ranges.

Solution – 1

=UNIQUE(FLATTEN(TRANSPOSE(Categorieen)))

Reference: FLATTEN