Copy portion of 3 columns 9 rows into 1 column 9 rows.

[west123]

help with this portion of stats to go in column S:
columns R19:T19, rows 19:27 to go into column S as show in picture.

Please note: that column S stats that show now is a picture I paste in column S. Results button i just put on top of picture.

[6StringJazzer]

One idea is to use formulas to refer to the data, but you cannot format individual characters in formula results (i.e., you have dark green, bright green, white--formula results have to all be the same color).

Another idea is to format the data how you want it (maybe another sheet?) and embed a linked image of that range. That is what I did for you. The data is on sheet Embed Image. Any changes to that data are reflected in the image I used to replace yours.

However, T26 and T27 are typed-in values so I'm not sure what you have in mind for them.

[west123]

thank you so much 6StringJazzer
would 1st method be better? I try fixing the formula for T26 & T27
T26: =COUNT(tbl_Tournaments[WINS])/COUNTA(tbl_Tournaments[Tournaments])
T27: =COUNT(tbl_Tournaments[Cashes])/COUNTA(tbl_Tournaments[Tournaments])
the bright green would be good to use in formula if we can changed, to 1st method.

[6StringJazzer]

The formulas can show the data but you will have to experiment to get the spacing the way you want it, because you are trying to show two columns of data in one column.

[west123]

thank you once again 6StringJazzer
its working as it should now. thank you.

will now marked this as solved. ty

[6StringJazzer]

You're welcome!