Hello,
I have values on Sheet 1 which contain prices in every other column in row I starting with I128 (skip J128) value in M128 and so on with the last value being in column Q128.
I am attempting to put these values in a clean spreadsheet (Sheet 2) uniformly across in rows K14 through O14. I can't click and drag because of the space in between each value in spreadsheet 1. I would rather not put a space in between each value on the new spreadsheet 2 as it would take up too much space.
Please let me know if you know a solution to this problem.
Thanks,
Jocelyn
I have values on Sheet 1 which contain prices in every other column in row I starting with I128 (skip J128) value in M128 and so on with the last value being in column Q128.
I am attempting to put these values in a clean spreadsheet (Sheet 2) uniformly across in rows K14 through O14. I can't click and drag because of the space in between each value in spreadsheet 1. I would rather not put a space in between each value on the new spreadsheet 2 as it would take up too much space.
Please let me know if you know a solution to this problem.
Thanks,
Jocelyn