Merging data from multiple sets of columns

[katrj]

Hi, 

I have the following set of data in my input:

A1 ID	A1 Due	A1 Completed	A2 ID	A2 Due	A2 Completed	A3 ID	A3 Due	A3 Completed
120	13-Jan-24		133	16-Jan-24	13-Apr-24	145	16-Jan-24
121	14-Jan-24	13-Feb-24	134	17-Jan-24		146	17-Jan-24
122	15-Jan-24		135	13-Jan-24		147	18-Jan-24	13-Mar-24
123	16-Jan-24	13-Feb-24	136	13-Jan-24		148	19-Jan-24

My purpose is to copy data from A2 ID, A2 Due, A2 Completed and A3 ID, A3 Due, A3 Completed

and paste them below all existing rows in A1 ID, A1 Due, A1 Completed. Outcome: content of columns A1 at top followed by content of A2 and A3.

Can you please suggest a solution? I tried using record id / transpose but did not get expected results. 

Desired output: 

A1 ID	A1 Due	A1 Completed
120	13-Jan-24
121	14-Jan-24	13-Feb-24
122	15-Jan-24
123	16-Jan-24	13-Feb-24
133	16-Jan-24	13-Apr-24
134	17-Jan-24
135	13-Jan-24
136	13-Jan-24
145	16-Jan-24
146	17-Jan-24
147	18-Jan-24	13-Mar-24
148	19-Jan-24

[binuacs · Accepted solution]

@katrj one way of doing this with the batch macro

[katrj]

Thanks! Some magic and it worked for my data set :)