Macro to merge data ( Transpose)

hello

I have a list of items that I would like a macro to repeat untill of the rows have been completed
In the spreadsheet
I would column row A3 to add information in c3 and add the value in C1
repeat the information with A3 now going to e3 and e1

repeat the process until all columns have been captured and put the date

repeat for A4

complete when all rows have been actioned ( there could be 1000 rows)

toe out put tab shows the outcome

Your help is greatly appreciated

Out put is on new sheet auto created by the code.

Thanks for this grealy appreciated , another great reason to use the forum

SOLVED

mapleleafs2412,
You are welcome!
Please mark it as solved on the thread itself. On the top right-hand side of this page, there is a menu and drop down option.