Rearranging value in an excel table (Transpose is not working for the desired output)

Vaibhav002 

It should be possible to achieve this with TOCOL and WRAPROWS alone but thinking it through is painful.  I have used the fact that the array can conveniently be divided into two, rearranged and, finally, reassembled.

= LET(
    n, COLUMNS(array) / 2,
    array1, TAKE(array,,n),
    array2, DROP(array,,n),
    VSTACK(TOROW(array1), TOROW(array2))
  )

A more 'nuts and bolts' approach would to calculate indices and then put the result together with MAKEARRAY and INDEX.