format column with compose

here i format row :

formatSpec = "%d - %s";

RowName=compose(formatSpec,t2,sis);

but if i want to format columns? how can i do?

[Dyuman Joshi]

Remove the prefix serial numbers and tranpose the output.

[piero]

"Remove the prefix serial numbers" what is?

[Dyuman Joshi]

The 1 -, 2 - , 3 - , ... you have at the start of the strings, which is not there in the 2nd image.

[piero]

i want to do this: "1 - A" "2 - B"

[dpb]

@piero is presuming (as best info we have since you didn't provide testing dataset) the "1 - " prefix in your first image is real.

If so, then

RowName=extractAfter(compose(formatSpec,t2,sis),"- ").';

should be the magic incantation you're looking for.

If not, attach a (small) example dataset for folks to play with...

[piero]

"should be the magic incantation you're looking for" :DD

RowColumn=RowName'; ==> this solution is ok! thank