Paste data into table and present it in a readable format

Heya everyone,

OK So I have a difficult one (for me hopefully not you) I'm getting raw data that needs to be presented in a readable way as the main goal and the same as the register we use to record it would be even more ideal

RAW Data file attached and what work I've done so far attached as well

So what I'm looking to do:

1) Delete columns A, B, C, D, E

2) Format Column F to 0 decimal places

3) Multiply Column I/J by 1000

(I have already deleted columns A-E in the upload example as they are GPS coordinates)

--------------------------------------------------

Now that was the easy part, now we get into the thick of it. We have a column called "offset" that should always be 0.5 2.5 4.5 6.5 8.5 10.5 (12.5)

The idea is to get the dip that corresponds to 0.5 to line up and so on for 2.5 4.5 etc the template will hopefully give you guys some idea

Your probable wondering why the 12.5 is in brackets, its because its not always included it depends on what is being measured. also the data needs to be presented Horizontally not vertically. I've been using transpose but I don't think that's the correct way to do it as I keep getting you can not change an array error. Also I'm not sure what to do with our wild card 12.5 as i cant tell it to transpose in a set order as even 1 12.5 will throw it off and finally they don't always read in order from 0.5 to 12.5 sometimes its the reverse and sometimes its the reverse starting from 10.5

Finally there are 2 Columns I/J they are pretty much the same data sometimes people record both and sometimes they only record one but I should be able to change any solution to adapt for this on a case by base basis

I'm at a total loss and I'm hoping some of you guys are able to offer some help,

Thanks for reading.

Maybe I should pay for this one :L