excel - Transform a column into a table -

i'm looking way transform single column table.

here's example:

enter image description here

my plan transform into

enter image description here

i'm using formula indirect(address((row($a1)-1)*2+column(a1);1)) output result.

enter image description here

and copy paste using transpose function.

so know if there way make work better , easier?

thank

for specific case, assuming data in sheet1!a1:a8 use in cell a1 on sheet:

=index(sheet1!$a$1:$a$8,(column()*2-1)+(row()-1),1)

and drag b1:d1 , a2:d2

Hide