Macros To Achieve Objective

I created two macros to achieve my objective. I used the "record a macro" function, which probably creates very ugly codes. My first code formats raw data in a certain fashion so that it can be easily extracted; I understand this code fairly well and have been able to make alterations to it with ease.

The second macro takes values from the formatted data and plugs them into a table. Unfortunately, the code that Excel wrote is very confusing to me.

Essentially, the data follows a pattern (new entries occur every 14 rows), but Excel's automated code is tedious to program. Here's an example:

Columns("R:R").Select
With Selection.Interior
.ColorIndex = 11
.Pattern = xlSolid
End With
Range("T2").Select
ActiveCell.FormulaR1C1 = "Acct"
Range("U2").Select
ActiveCell.FormulaR1C1 = "Org Name"
Range("V2").Select
ActiveCell.FormulaR1C1 = "Pmt Type"...............