Wrap an array which has two columns

djclements  , flexyourdata 

Thanks for your quick response.

While trying few solutions, I found a single cell formula without using let, lambda.

Here is my formula.

=IFERROR(INDEX(TOCOL(TRANSPOSE(VSTACK(DataSheet[#Headers],
FILTER(DataSheet,$B$1=DataSheet[PC NAME],"Not Available"))),0,FALSE),
SEQUENCE(9,6,1,1)),"")

Currently my table has 27 columns in my table and I am displaying it along with column headers.

So in my case I was required to block 54 cells [ 27 for data and 27 for headers].

One can make it flexible by using variables in sequence function to make it dynamic.

Now I can see my data of 27 rows and 2 col in 9 rows and 6 col.

I will appreciate your feed back.