- Aug 29, 2014
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!
|Well 1||04/14 O RI||200||10||TX|
|Well 2||03/14 G WI||100||4||LA|
|Well 1||04/14 O RI||200||10||TX||04/14||O||RI||10||5||4|
|Well 2||03/14 G WI||100||4||LA||03/14||G||WI||5||4|