Macro to Reverse Order of Columns but Dependent on Number of Data Rows

I am in need of a macro that essentially reverses the order of a set of columns and changes their formats to a couple specific formats (ex: ##+##.## and ##.##'). I am trying to eliminate manual input into excel to get the correct data I can import to Autocad. My data comes in the format of three columns (C,D,E). The problem is the data varies and can fill 20 rows or it can fill 120 rows, etc. I need the macro to be able to accomodate manipulating the data despite the amount of rows which is my main problem.

I'm attaching two sheets. One has the first macro ran which is a set of formulas I created to get the data I need. The formulas start at column P because in normals circumstances, I have various other info up to column O, but I don't utilize this.
The first macro I created works fine except it doesn't account for variable row lengths (which I need it to).
The second sheet I'm attaching shows the end result of what I need. I attempted to make a macro, but it doesn't seem to work correctly. There may be a much easier way to reverse column orders, but to my knowledge, this is the only way I know.

Any help would be greatly appreciated. And if any other information is needed, I'll be glad to provide it.
Workbook First Macro Ran.xlsmWorkbook Second Macro Ran.xlsm