Welcome to the forum!

Hi, in this case, you need simple math to get the job done.

Usually, if you want something to be done in a pattern, you must figure out the pattern first mathematically (since Excel determines the pattern mathematically).

If you take a look at your example, you can convert the column name to a number where A = 1, B = 2, C = 3...

So, if you were to put them in a table

1 (A) | 2 (B) | 3 (C) | 4 (D) | 5 (E) | 6 (F) | 7 (G) |

| Segment 1 | | Segment 1.1 | | Segment 1.2
| |

<tbody>

</tbody>

You can see that you have only filled in values for

**even** numbers.

So, the first step for doing what you want is to know how to print values for only EVEN numbered columns.

**PRINTING FOR EVEN COLUMN NUMBERS**
You can achieve this by using combination of IF, COLUMN and MODULUS formula.

The COLUMN formula simply returns the column number of the reference.

The MODULUS formula returns the remainder of a number you have divided by dividend

So, 5 MODULUS 2 would return 1

**=MOD(5, 2)**
6 MODULUS 2 would return 0

**=MOD(6,2)**
7 MODULUS 5 would return 2

**=MOD(7,5)**
So, to print only for even numbers, you would use this formula in D1.

=IF(MOD(COLUMN(),2)=0,B1, "")
where B1 is already filled in with "Segment 1"

However, when you copy over and check your formulas, you will realize the formula in F1 would look something like

=IF(MOD(COLUMN(),2)=0,D1, "")
which is something you don't want.

Why?

Because in D1, you're planning to have "Segment 1.1" and if you refer to D1 for "Segment 1.2", you will have to fiddle around with "Segment 1.1" to get the value you want. When you could get "Segment 1.2" much easier by using B1 unconditionally!

**ABSOLUTE REFERENCE**
To use B1 unconditionally in any cells with copied formula, you must use

**Absolute Reference.**

You can achieve this by using

**$** sign.

So, in D1 change the formula to

=IF(MOD(COLUMN(),2)=0,$B1, "")
and copy over to other columns and check F1 again!

It should look like

=IF(MOD(COLUMN(),2)=0,$B1, "")
Because the column of B1 has been absolutely referenced, B will not change in any cells copied over.

Try putting absolute reference for row number or both {column, row} and play around with it.

*APPLYING*
Now that you have almost all the things you need to do for this, let's try solving it.

1) To print only for even numbered columns, in D1

=IF(MOD(COLUMN(),2)=0,"Printing message", "")

2) To add values to B1.. in D1

**=IF(MOD(COLUMN(),2)=0,$B1 & "." & COLUMN()/2-1,"")**
The step 2 does it all with only one new QUOTIENT formula, which is similar to MODULUS formula (both found by simple division)

Hope it helps.