Instead of copying and pasting, try this formula, which will give you the
data configuration that you're looking for.
Enter this formula *anywhere*, then copy across one column.
Then, select *both* cells, and drag down the 2 cell selection as far as
needed.
=INDEX($B$2:$B$250,2*ROWS($1:1)+COLUMNS($A:A)-2)
After you have all the data displayed as needed, you can remove the formulas
and leave just the data behind by copying to itself and then "Paste
Special", and click on "Values", then <OK>.
--
HTH,
RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================
How can I select every other cell in Row B, from row 2 thru row 250?
Data looks like this...
Item1
price1
Item2
price2
I need...
Item1 price1
Item2 price2
so if I can select every other cell in the column, i can move them the
correct column.