Rod
Rod

Reputation: 15475

How can I move every other record to correct row and col programmatically

How can I move every other record to correct row and col programmatically?

Given:
row1 colA   
row1 colB   
row2 colA   
row2 colB   
    

Desired:    
row1 colA   row1 colB
row2 colA   row2 colB

Upvotes: 0

Views: 42

Answers (1)

user11222393
user11222393

Reputation: 5501

If using Office 365 WRAPROWS could help. Formula: =WRAPROWS(A1:A10,2)

Result:

enter image description here

Upvotes: 2

Related Questions