mooseapalooza
New Member
- Joined
- Jul 23, 2007
- Messages
- 2
This is a pretty simple issue but I cant figure out a straightforward way do to it (I only started using excel at my new job a few weeks ago). I have a column with 100 data points in it. Each data point is seperated by 24 blank cells. Hence, cell A1 has some value, cells A2-A25 are empty, cell A26 has some value,...and so on for a few thousand cells.
I want to get rid of the blank spaces. I want cell A1 to contain its value. cell A2 to contain cell A26 value, cell A3 to contain cell A51 value, and so on.
Please help. I am banging my head against my cubicle in frustration.
I want to get rid of the blank spaces. I want cell A1 to contain its value. cell A2 to contain cell A26 value, cell A3 to contain cell A51 value, and so on.
Please help. I am banging my head against my cubicle in frustration.