Count and output letters in order

[bestnagi]

What is the best way to have the table output the letters in certain order and certain number of time.

Table has input X,Y,Z . For each X,Y,Z, it shows how many times they are repeated in the output in that order X,Y,Z.

X	Y	Z
2	1	1	X	X	Y	Z
1	2	0	X	Y	Y

<tbody>
</tbody>

 

[Peter_SSs]

That works prefect!

That's good news and thanks for letting us know.
However, you have had 3 suggestions since you last posted and it would be helpful to readers of the thread if they could identify which suggestions you have tried and which one this comment refers to.

 

[hiker95]

bestnagi,

When you respond to your helper, please use their site ID/username/handle.

This will keep thread clutter to a minimum and make the discussion easier to follow.

 

[István Hirsch]

Another version:

=MID(REPT($A$1,$A2)&REPT($B$1,$B2)&REPT($C$1,$C2),COLUMNS($A:A),1)

Excel Workbook
	A	B	C	D	E	F	G	H
1	X	Y	Z
2	2	1	1	X	X	Y	Z
3	1	2	0	X	Y	Y
4	0	0	0
5	0	0	4	Z	Z	Z	Z
6	3	0	1	X	X	X	Z
7	4	0	0	X	X	X	X
8	0	2	0	Y	Y
Sheet

 

[Peter_SSs]

Another version:

=MID(REPT($A$1,$A2)&REPT($B$1,$B2)&REPT($C$1,$C2),COLUMNS($A:A),1)

Another good one István.
I would, however, recommend one small change. As it stands your formula returns the correct results. However if the user now decides to separate the data and the output by inserting a new column D the results will be incomplete.
I think it would be more robust if the column count was based on where the formulas actually reside:

=MID(REPT($A$1,$A2)&REPT($B$1,$B2)&REPT($C$1,$C2),COLUMNS($D:D),1)

 

[István Hirsch]

Thanks Peter, I did not pay attention to post #6.