data rows to data columns and rows in sequence

[Butehawk]

I have a sheet that contains 2100 rows of data across A-CR, each row is a complete set of data.
In order to get the data to upload into a new programme it requires to be in column format with a unique reference number from column A in the original to be inserted again in column A for each 63 rows of data. This I think is the easy part.

I have made my first 63 rows of date in columns B-T from the original and linked the cells on the new sheet to the original where needed.
I can cut and past the 63 rows each time and then use "replace to change the row number by 1 in the cell lookup reference but this will take for ever.
Is there a way to do this quickly.
I require i.e. '(sheet name.xlsx)main'!$P$3 to change to '(sheet name.xlsx)main'!$P$4
'(sheet name.xlsx)main'!$Q$3 to change to '(sheet name.xlsx)main'!$Q$4 etc every time I past the 63 rows of data.

Is there an easy fix? I have uploaded the new sheet.
Can anybody help

Roger

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

This is actually an Excel Forum,so every post requires help with a spreadsheet!

[Butehawk]

Sorry first time asking a question after a long hard day.

[shg]

Think you need to post the Before sheet as well, assuming this is the After.