Add Value Between Each Row

[ExcelToDAX]

If I had the following table:

Mister

Excel

Dot

Com

Help

Me

Figure

This

Out

Using Excel formulas, how could I have it output as the following below table to insert "% of Values" in between each row of data:

Mister

% of Values

Excel

% of Values

Dot

% of Values

Com

% of Values

Help

% of Values

Me

% of Values

Figure

% of Values

This

% of Values

Out

 

[Eric W]

Try:

Book1
	A	B	C
1	Mister		Mister
2	Excel		% of values
3	Dot		Excel
4	Com		% of values
5	Help		Dot
6	Me		% of values
7	Figure		Com
8	This		% of values
9	Out		Help
10			% of values
11			Me
12			% of values
13			Figure
14			% of values
15			This
16			% of values
17			Out
18
Sheet1

Cell Formulas
Range	Formula
C1:C17	C1	=LET(a,A1:A9,s,SEQUENCE(2*ROWS(a)-1),IF(MOD(s,2),INDEX(a,(s+1)/2),"% of values"))
Dynamic array formulas.

 

[StephenCrump]

Another way ....

=TEXTSPLIT(TEXTJOIN("|% of values|",,A1:A9),,"|")