We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
I've got an Open Office Calc spreadsheet set out as below
and I would like to insert a blank row after every fourth row.
Any suggestions would be greatly appreciated.
| A | B | C | D | E | F | G |
| Date | Time | Course | Qualifier | ISP | Position | Runners |
| 11/04/03 | 14:30 | Thirsk | High Diving | 1.25 | 2nd | 7 |
| 17/04/03 | 16:25 | Ripon | Excellento (USA) | 0.73 | 1st | 10 |
| 28/04/03 | 14:45 | Hamilton | Fantastic Love (USA) | 0.13 | 1st | 5 |
| 03/05/03 | 13:55 | Thirsk | Fiore Di Bosco (IRE) | 1.2 | 2nd | 7 |
| 14/05/03 | 14:30 | York | Dunhill Star (IRE) | 2.75 | 3rd | 10 |
| 16/05/03 | 19:55 | Hamilton | Rahbar | 0.62 | 3rd | 6 |
| 23/05/03 | 16:45 | Haydock | Cake It Easy (IRE) | 0.53 | 1st | 5 |
| 27/05/03 | 14:30 | Leicester | Crown Agent (IRE) | 4.5 | UR | 19 |
| 01/06/03 | 14:50 | Pontefract | Well Chosen | 2.5 | 4th | 9 |
| 03/06/03 | 14:15 | Lingfield | Harry Up | 0.18 | 1st | 5 |
| 22/06/03 | 14:50 | Pontefract | Clever Clogs | 0.44 | 1st | 5 |
and I would like to insert a blank row after every fourth row.
Any suggestions would be greatly appreciated.
Show More
google:- insert blank rows at regular intervals excel
you get some help on writing a macro for that sort of thing
you get some help on writing a macro for that sort of thing
shemnel
Thanks for the advice.
To clarify, I would like to insert a blank row after every fourth row of data down to row 1001.
Off googling now.
Thanks for the advice.
To clarify, I would like to insert a blank row after every fourth row of data down to row 1001.
Off googling now.
You could do this ~
Using 2 helper columns H and I
Select cell A1:I1 and click data menu, filter
In H1 type 3
In H2 next to your first date Paste =IF(H1=3,1,H1+1)and fill down till end of data.
In I3 next to your first date Paste =IF(H1=3,I1+1,I1)And fill down till end of data.
After the last figure in col. I type 1 and next cell down type 2 and grab the fill handle on those two cells and fill in consecutive number order down for the number of rows which is the last biggest number in col I
Clicking the down arrow in cell I1, sort (smallest to largest)
You can then clear or delete col H and I
Cheers
Using 2 helper columns H and I
Select cell A1:I1 and click data menu, filter
In H1 type 3
In H2 next to your first date Paste =IF(H1=3,1,H1+1)and fill down till end of data.
In I3 next to your first date Paste =IF(H1=3,I1+1,I1)And fill down till end of data.
After the last figure in col. I type 1 and next cell down type 2 and grab the fill handle on those two cells and fill in consecutive number order down for the number of rows which is the last biggest number in col I
Clicking the down arrow in cell I1, sort (smallest to largest)
You can then clear or delete col H and I
Cheers
another helper column alternative is :-
auto fill a column numbered 1 2 3 4 5 6 7 8 9 10 11 12 13 etc
at the end of the column autofill it so that it gives 4.5, 8.5, 12.5 etc
when you sort the column you will have a blank row every 4th row
auto fill a column numbered 1 2 3 4 5 6 7 8 9 10 11 12 13 etc
at the end of the column autofill it so that it gives 4.5, 8.5, 12.5 etc
when you sort the column you will have a blank row every 4th row
Excellent! starfish and coffee
Much simpler than my effort and after reading the problem
again I had an error of making my answer, putting a blank row after every 3 rows of data. Yours is correct after every 4 rows of data.
He will have to fill the 4.5,8.5 etc down till it reaches at least 1001.5
Cheers
Much simpler than my effort and after reading the problem
again I had an error of making my answer, putting a blank row after every 3 rows of data. Yours is correct after every 4 rows of data.
He will have to fill the 4.5,8.5 etc down till it reaches at least 1001.5
Cheers
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539