Evening , I have a list of data in columns Q R S and i need to in between each line insert the data from columns
D E F underneath and then underneath that the data from G H I
so bascially i have a list at the moment like this
Match Odds Result
Motherwell v Inverness0-0 DRAW<D5> 9.0 LOSE
Kilmarnock v Mothewell 0-0 DRAW<D5> 13.0 Win
Dortmund v Hamburg 0-0 DRAW<D5> 9.0 LOSE
BUt i need it to be like this
Match Odds Result
Motherwell v Inverness0-0 DRAW<D5> 9.0 LOSE
1-1 DRAW 8.0 LOSE
2-2 DRAW 19.0 LOSE
3-3 DRAW 80.0 LOSE
4-4 DRAW 750.0 LOSE
Kilmarnock v Mothewell 0-0 DRAW<D5> 13.0 Win
1-1 DRAW 8.0 LOSE
2-2 DRAW 19.0 LOSE
3-3 DRAW 80.0 LOSE
4-4 DRAW 750.0 LOSE
Dortmund v Hamburg 0-0 DRAW<D5> 9.0 LOSE
1-1 DRAW 8.0 LOSE
2-2 DRAW 19.0 LOSE
3-3 DRAW 80.0 LOSE
4-4 DRAW 750.0 LOSE
There is 2 sheets in total , 1 i need to inc 1-1 draw as above and the other sheet
to be exc the 1-1 draw .
I have attached an example of what i am trying to achieve .
would appreciate any help anybody can offer
Regards Matt
Bookmarks