Forum Discussion

rlight1959's avatar
rlight1959
Copper Contributor
Nov 19, 2020

Moving Data from Columns to Rows

Help! before I do manual keying of data, I wanted to ask this question.  Not sure thIs is possible; is there a way to move data from two columns into the rows.  I tried Transpose function and a few o...
excel
mtarler's avatar
mtarler
Silver Contributor
Nov 19, 2020

rlight1959 Here is a formula you can use.  I have the data in the range b1:c4

=INDEX(B1:C4,INT(SEQUENCE(1,2*ROWS(B1:C4),1,0.5)),ISEVEN(SEQUENCE(1,2*ROWS(B1:C4)))+1)

 

Resources