Forum Discussion
Selecting cells for every fourth column in a single row
Hi All, Does anyone know how to get values evenly spaces across on row (so in the same row but different columns (every 4th column)) selected and copied so that they now appear below each other i...
Hi OskarONL
You can copy the row and transpose it to columns
hight the row --> Copy --> go the place where you want to paste it, and right click --> special paste
On the window that will appear tick the transpose option on the right down of the windows.
Do all the cells in the row have value (B66,C66,D66) or just the last cell E66?