jwalkerack
Board Regular
- Joined
- Jun 19, 2013
- Messages
- 81
Hi there ,
i have a data set that is populated in a table , there are two set of data. one are fixed points such as time , location .
The other are variables specifically its a test number and test depth. For each sheet there are different amount of values . One test might have 30 rows of data the next might have 50.
What i want to be able to do is fill down my fixed data so it corresponds to the amount of test present.
So i have my data set below. I only have 1 entry for the first 4 columns , i would like this to be filled down to correspond to the 27 row. i have tried doing a copy and paste recorder . But my problem is that this will only copy to the values in the first test. In because the amount of rows will always change . i was wondering if there is a way of doing this . Thanks a lot Jack
<colgroup><col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:4205;width:86pt" width="115"> <col style="mso-width-source:userset;mso-width-alt:3035;width:62pt" width="83"> <col style="mso-width-source:userset;mso-width-alt:7314;width:150pt" width="200"> <col style="mso-width-source:userset;mso-width-alt:4937;width:101pt" width="135"> <col style="mso-width-source:userset;mso-width-alt:4096;width:84pt" width="112"> </colgroup><tbody>
</tbody>
i have a data set that is populated in a table , there are two set of data. one are fixed points such as time , location .
The other are variables specifically its a test number and test depth. For each sheet there are different amount of values . One test might have 30 rows of data the next might have 50.
What i want to be able to do is fill down my fixed data so it corresponds to the amount of test present.
So i have my data set below. I only have 1 entry for the first 4 columns , i would like this to be filled down to correspond to the 27 row. i have tried doing a copy and paste recorder . But my problem is that this will only copy to the values in the first test. In because the amount of rows will always change . i was wondering if there is a way of doing this . Thanks a lot Jack
location | Test Date | Test Type | Action number | Report Test Number | Depth |
1_234_1234 | 30/04/1990 | longhand | 4 | 1 | 15115 |
2 | 15110 | ||||
3 | 15111 | ||||
4 | 15164.9 | ||||
5 | 15246.9 | ||||
6 | 15302 | ||||
7 | 15303 | ||||
8 | 15359.9 | ||||
9 | 15356.9 | ||||
10 | 15405.9 | ||||
11 | 15417.9 | ||||
12 | 15445 | ||||
13 | 15489 | ||||
14 | 15493 | ||||
15 | 15491 | ||||
16 | 15555 | ||||
17 | 15553 | ||||
18 | 15682 | ||||
19 | 15702 | ||||
20 | 15700.9 | ||||
21 | 15766 | ||||
22 | 15828 | ||||
23 | 15885.8 | ||||
24 | 15904 | ||||
25 | 15888 | ||||
26 | 15685 | ||||
27 | 15766 |
<colgroup><col style="mso-width-source:userset;mso-width-alt:5010;width:103pt" width="137"> <col style="mso-width-source:userset;mso-width-alt:4205;width:86pt" width="115"> <col style="mso-width-source:userset;mso-width-alt:3035;width:62pt" width="83"> <col style="mso-width-source:userset;mso-width-alt:7314;width:150pt" width="200"> <col style="mso-width-source:userset;mso-width-alt:4937;width:101pt" width="135"> <col style="mso-width-source:userset;mso-width-alt:4096;width:84pt" width="112"> </colgroup><tbody>
</tbody>