Please Help!

S

samsg

Hi, i have a list of values like this:

54
24
31
...

I want to place number 54 and then leave 4 blank spaces, the place
number 24, and 4 blanks, and so on, so it would look like this

54


24


31
...

How can i do this automatically?, the list is too long to insert 4
cells and then press f4 for each value, is there an autofill that can
skip rows , or something that can help me??

Thanks a lot for the help
 
M

Max

One way to try (adapted from a previous Tom Ogilvy post)

Assume you have in Sheet1, in A1 down

54
24
31
etc

In Sheet2
------------
Put in any starting cell, say B2:

=IF(MOD(ROW(A1),5)=1,OFFSET(Sheet1!$A$1,(ROW(A1)+4)/5-1,COLUMN(A1)-1),"")

Fill B2 down

This'll return the desired results in B2 down, viz.:
54, 4 blanks, 24, 4 blanks, 31, 4 blanks, etc

If required, just kill the formulas thereafter
with an "in-place" copy > paste special > values
 
Top