baustin123
New Member
- Joined
- Aug 29, 2014
- Messages
- 2
I am looking at formatted data that I need to create a table with. In the example in column B, there are three separate pieces of data that I need. I am looking to copy that information to columns H, I, J. There is also associated information on the rows below in Column D. Rows 3 and 4 related to Row 2. Row 6 with Row 5. I am looking to accurately move this data as well. Please see before and after below.THANKS!
<tbody>
</tbody>
| BEFORE | Date | Prod | INT | TX | OR | LA | ||||||||
| Well 1 | 04/14 O RI | 200 | 10 | TX | ||||||||||
| 5 | OR | |||||||||||||
| 4 | LA | |||||||||||||
| Well 2 | 03/14 G WI | 100 | 4 | LA | ||||||||||
| 5 | OR | |||||||||||||
| AFTER | ||||||||||||||
| Well 1 | 04/14 O RI | 200 | 10 | TX | 04/14 | O | RI | 10 | 5 | 4 | ||||
| 5 | OR | |||||||||||||
| 4 | LA | |||||||||||||
| Well 2 | 03/14 G WI | 100 | 4 | LA | 03/14 | G | WI | 5 | 4 | |||||
| 5 | OR | |||||||||||||
<tbody>
</tbody>
