Consolidate many columns into three

Dear all,

I am new to this forum and I apologize for any error in posting this question (right place/ right format etc..).

I am also new to VBA, but I program in C++ and R, so I can follow your hints.

Here's my problem: I have a database in Excel which is formatted in a strange way: three variables repeated many times but with a different number of observations each time, for example...

Variable 1	Variable 2	Variable 3	Variable 1	Variable 2	Variable 3	Variable 1	Variable 2	Variable 3
34	57	21	65	67	89	9	1	20
12	45	68	53	89	32	16	72	14
14	54	87	9	2	4	6	98	24
23	54	98	76	34	90	14	21	65
			12	53	87	9	63	97
			45	76	76

.. and I need:

Variable 1	Variable 2	Variable 3
34	57	21
12	45	68
14	54	87
23	54	98
65	67	89
53	89	32
9	2	4
76	34	90
12	53	87
45	76	76
9	1	20
16	72	14
6	98	24
14	21	65
9	63	97

Thank you very much for your help!

Well I can't imagine it would take that long to set this up manually (select D2:F2, ctrl+shift+down arrow, copy and paste to first empty row in col A, repeat for H2:I2) but as a coded version, assuming your data starts at A1:

Please Login or Register  to view this content.

For what it's worth, I'd use this for arbitrary number of columns

Please Login or Register  to view this content.

That is gobbledygook to me...

Sorry, I hope you can view the tables now in some way...

haha, looks a bit better now, afraid I still can't view those images on my work server though. It would be best to upload a workbook with your desired tables on separate worksheets.

To upload:
-when replying click - go advanced, then attachments.

Here comes the attachment...

I think you need something like this (run it with the "what i have" sheet active):

Please Login or Register  to view this content.

Thank you so much, yudlugar!!! You are the man!
Wow, you saved me so much time! Thanks!!!