Move data via macro

Move data via macro

OK first off, all the data is originally in a xlsm file. A macro runs (via
task scheduled)and make the tabs into csv file. Work perfectly.
Second I have a website that reads the data, and displays it in a graph.
The javascript that i used to make this work, reads the data from columns.
works perfectly.
Now for the problem... The csv files that are exported via the macro,
don't read properly. this is due to the first and last lines of data.
first line i don't need, however i can use the last line.
So here i want i ask... 1. how do i remove the first row 2. is there a way
i can move the row into the next column.
This is what it looks like now.
Auto+Hide Fit Fit Fit
No. Name Comm MTD
E00043 Julie 2
E00143 Jodie 1
E00198 Jason 0
E00289 Ronald 0
E00345 Patimah 2
E00356 Jenny 1
TARGET 6
I would like it to look like this.
No. Name Comm MTD TARGET
E001 Julie 2 6
E002 Jodie 1
E003 Jason 0
E004 Ronald 0
E005 Patimah 2
E006 Jenny 1
I don't want to manually edit the data if possible, as this process is
meant to be automated.
Any help would be appreciate