I'm not clear what type of macro you are trying to create.

Do you want to transpose the data from rows to columns?

Is the template spreadsheet the file specification for the file to
import into Oracle?

Please show the code for your macro.