I have an issue. I told my wife I could write a script for this. Well its a bit out of my range. I thought it was easy but its not for me because I dont do this enough.
I have a spreadsheet and lets say I need to copy A2, D2, and E2 to another sheet 20 times but I also need to transpose the headings from columns CK1:DD1 into Column D, and then Transpose CK2:DD2 into column E. This is the data set (20).
Then I need to loop for each row this until the end of the list for lets say column D.
CK1:DD1 will always be the same 20 for each row that is copied.
Can anyone help? I know its a loop and transposing but not sure how to go about it.
Final result would look like this for each row from original sheet into final.
<tbody>
</tbody>
I have a spreadsheet and lets say I need to copy A2, D2, and E2 to another sheet 20 times but I also need to transpose the headings from columns CK1:DD1 into Column D, and then Transpose CK2:DD2 into column E. This is the data set (20).
Then I need to loop for each row this until the end of the list for lets say column D.
CK1:DD1 will always be the same 20 for each row that is copied.
Can anyone help? I know its a loop and transposing but not sure how to go about it.
Final result would look like this for each row from original sheet into final.
Data1 | Data2 | Data3 | Data4 | Data5 |
A2 | D2 | E2 | CK1 | CK2 |
A2 | D2 | E2 | CL1 | CL2 |
A2 | D2 | E2 | CM1 | CM2 |
A2 | D2 | E2 | CN1 | CN2 |
A2 | D2 | E2 | CO1 | CO2 |
A2 | D2 | E2 | CP1 | CP2 |
A2 | D2 | E2 | CQ1 | CQ2 |
A2 | D2 | E2 | CR1 | CR2 |
A2 | D2 | E2 | CS1 | CS2 |
A2 | D2 | E2 | CT1 | CT2 |
A2 | D2 | E2 | CU1 | CU2 |
A2 | D2 | E2 | CV1 | CV2 |
A2 | D2 | E2 | CW1 | CW2 |
A2 | D2 | E2 | CX1 | CX2 |
A2 | D2 | E2 | CY1 | CY2 |
A2 | D2 | E2 | CZ1 | CZ2 |
A2 | D2 | E2 | DA1 | DA1 |
A2 | D2 | E2 | DB1 | DB2 |
A2 | D2 | E2 | DC1 | DC2 |
A2 | D2 | E2 | DD1 | DD2 |
<tbody>
</tbody>