Cut and paste using vba script

Closed
Report
-
Hello,
I'm looking for a VBA script for the following scenario, kind request to suggest a method.

Ques:
I've a series of columns Range (A:HZ) (around 168 columns) with 10rows (fixed). I want to cut every 2 columns (following from C:D, E:F till HZ) and concatenate the cut columns below the first 2 columns (A:B) after 11th row and further keep increasing row count to paste other 2columns beginning from 22nd row. Further move on towards right side of the remaining columns and keep concatenating below one after the other.

Sorry i couldn't capture the snapshot or attach the file that I wanted to show, due to security reasons in my company.

If any one can reply, then that shall reduce my editing time in excel and preparing the MS Word document.
Appreciate quick reply.
Thanking you.

I tried my best to create a table that I'm handling now, and the expected results as below.

A B C D ......... HZ
Attributes Contents Attributes Contents
Requirement ID 1 Requirement ID 2
Requirements abc Requirements abc
System State Mode System State Mode
Rationale SRS Rationale SRS
Priority M1 Priority M1
Risk TBD Risk TBD
Related ID TBD Related ID TBD
Status NA Status NA
Verification Criteria TBD Verification Criteria TBD

Expected Results

A B
Attributes Contents
Requirement ID 1
Requirements abc
System State Mode
Rationale SRS
Priority M1
Risk TBD
Related ID TBD
Status NA
Verification Criteria TBD

Attributes Contents
Requirement ID 2
Requirements abc
System State Mode
Rationale SRS
Priority M1
Risk TBD
Related ID TBD
Status NA
Verification Criteria TBD

:
:
:
:

until all the columns towards right are concatenated one below the other.