Move Every 2nd or third row to a new column in Google Sheet & Excel


Paste the data from A1 in the column….

next to it paste the following formula

=IF(MOD(ROW(),3)=1,OFFSET($A1,COLUMN()-2,0),"")

Drag it right for 2 columns

then drag to the bottom…


Leave a Reply

Your email address will not be published.