Hello...I have a group of cells like this....



column A:
row1: coffee
row2: cups
row3: napkins
row4: straws

I need to move those cells up one row and to the right one column so that it's like this...

column A.............column B
row1: coffee.........cups
row 2: napkins......straws


...Does somebody know how I can do it? thanks

In C1: =IFERROR(INDEX($A$1:$A$20,2*ROW()-1),"")
In D1: =IFERROR(INDEX($A$1:$A$20,2*ROW()),"")

Copy the formulas down.
Take a copy of c1:d20.
Select cell A1 and paste as values.

xor thanks!