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:


But I would like to use the named range


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


Reference: FLATTEN

Rate this post
We use cookies in order to give you the best possible experience on our website. By continuing to use this site, you agree to our use of cookies.