Data Insertion

[rlwfish]

Hello All,

One of my graduate courses requires the use of a fairly user unfriendly logit model estimator that cannot read excel data. What I need to be able to do is take a known, repeating set of values and insert data from a given column or columns between those know values, for up to n data points.

For instance:

If the known values were the column data:

a
b
c

and I have a set of observed data points:

1
2
3
4
5
6

what I need to do is get a new column:

a
b
c
1
a
b
c
2
a
b
c
3

etc...

I need to do this for about 4000 data points and eventually I will need to be able to insert multiple columns between each set of known values, i.e.:

known values:

a
b
c

data:

1
2
3
4
5
6

&

7
8
9
10
11
12

and get:

a
b
c
1
7
a
b
c
2
8
a
b
c
3
9

etc, up to 4000 times

Sorry for the length of this post, I hope you can help!

[Cheeky Charlie]

Are your known repeating values also variable length?

If no, a sensible formula could be derived.

If yes, the only practical option I see would be a macro - how are you with VBA?