How To Extract Table Data From a PDF / Copy/Paste to CSV

Hello,

My goal is to utilize pdf table data to populate a csv file. A simple copy & paste only serves to populate 1 column with all data. Ideally, I would like the columns to remain intact when copying and pasting over.

I can go line by line copying and transposing the desired rows into the original columns but would like to automate this process to better understand for loops in VBA.

Utilizing the Record Macro Functionality I have come up with this:

Sub Test()
'
' Test Macro
'
' Keyboard Shortcut: Ctrl+j
'
    Range("A2:A9").Select
    Selection.Copy
    Range("A1").Select
    Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True
End Sub