Hi,
Would like to ask help. I have this 1 column data below:
I would like to copy data in between "Performance Win Only" and "Opens:" to make it like below:
Also, copy data in between "Straight Forecast" and "Opens" to make it like below:
Would like to ask help. I have this 1 column data below:
Golf Data.xlsx | |||
---|---|---|---|
A | |||
1 | Performance Win Only | ||
2 | Mickelson, Jake | ||
3 | 23 | ||
4 | n | ||
5 | Si Woo Jun | ||
6 | 23 | ||
7 | n | ||
8 | Steele, Brick | ||
9 | 23 | ||
10 | n | ||
11 | Dahmen, Nina | ||
12 | 29 | ||
13 | n | ||
14 | Garcia, Srick | ||
15 | 29 | ||
16 | n | ||
17 | Spieth, Michael | ||
18 | 31 | ||
19 | n | ||
20 | Varner , Franco | ||
21 | 31 | ||
22 | n | ||
23 | Lowry, Nica | ||
24 | 34 | ||
25 | n | ||
26 | Grillo, Emiliano | ||
27 | Opens: | ||
28 | 200908 1211 | ||
29 | Suspends: | ||
30 | 200910 1600 | ||
31 | Closes: | ||
32 | Straight Forecast | ||
33 | 1. Garcia, Sergio/2. Mickelson, Phil | ||
34 | 541 | ||
35 | n | ||
36 | 1. Mickelson, Phil/2. Garcia, Sergio | ||
37 | 541 | ||
38 | n | ||
39 | 1. Mickelson, Phil/2. Steele, Brendan | ||
40 | 541 | ||
41 | n | ||
42 | 1. Steele, Brendan/2. Mickelson, Phil | ||
43 | 541 | ||
44 | n | ||
45 | 1. Lowry, Shane/2. Mickelson, Phil | ||
46 | 601 | ||
47 | n | ||
48 | Opens: | ||
49 | 200908 1211 | ||
50 | Suspends: | ||
51 | 200910 1600 | ||
52 | Closes: | ||
Sheet4 |
I would like to copy data in between "Performance Win Only" and "Opens:" to make it like below:
Golf Data.xlsx | |||||||
---|---|---|---|---|---|---|---|
F | G | H | I | J | |||
1 | |||||||
2 | Mickelson, Jake | Mickelson, Jake | 23 | n | |||
3 | 23 | Si Woo Jun | 23 | n | |||
4 | n | Steele, Brick | 23 | n | |||
5 | Si Woo Jun | Dahmen, Nina | 29 | n | |||
6 | 23 | Garcia, Srick | 29 | n | |||
7 | n | Spieth, Michael | 31 | n | |||
8 | Steele, Brick | Varner , Franco | 31 | n | |||
9 | 23 | Lowry, Nica | 34 | n | |||
10 | n | ||||||
11 | Dahmen, Nina | ||||||
12 | 29 | ||||||
13 | n | ||||||
14 | Garcia, Srick | ||||||
15 | 29 | ||||||
16 | n | ||||||
17 | Spieth, Michael | ||||||
18 | 31 | ||||||
19 | n | ||||||
20 | Varner , Franco | ||||||
21 | 31 | ||||||
22 | n | ||||||
23 | Lowry, Nica | ||||||
24 | 34 | ||||||
25 | n | ||||||
Sheet4 |
Also, copy data in between "Straight Forecast" and "Opens" to make it like below:
Golf Data.xlsx | ||||||
---|---|---|---|---|---|---|
L | M | N | O | |||
1 | ||||||
2 | 1. Garcia, Sergio/2. Mickelson, Phil | 1. Garcia, Sergio/2. Mickelson, Phil | 541 | n | ||
3 | 541 | 1. Mickelson, Phil/2. Garcia, Sergio | 541 | n | ||
4 | n | 1. Mickelson, Phil/2. Steele, Brendan | 541 | n | ||
5 | 1. Mickelson, Phil/2. Garcia, Sergio | 1. Steele, Brendan/2. Mickelson, Phil | 541 | n | ||
6 | 541 | 1. Lowry, Shane/2. Mickelson, Phil | 601 | n | ||
7 | n | |||||
8 | 1. Mickelson, Phil/2. Steele, Brendan | |||||
9 | 541 | |||||
10 | n | |||||
11 | 1. Steele, Brendan/2. Mickelson, Phil | |||||
12 | 541 | |||||
13 | n | |||||
14 | 1. Lowry, Shane/2. Mickelson, Phil | |||||
15 | 601 | |||||
16 | n | |||||
Sheet4 |