Multiply number by text

[learningstatistics]

I am trying to create combinations and I have a matrix that look like that:

E	W	O	N
1	2	0	3
3	2	1	1
1	2	0	0

<tbody>
</tbody>

I want to have it look like that:

1E-2W-0o-3N

3E-2W-1o-1N

1E-2W-0o-0N

<tbody>
</tbody>

 

[mikerickson]

If "E" is in A1

Then you could put this in E2 and drag down

=A2&A$1&"-"&B2&B$1&"-"&C2&C$1&"-"&D2&D$1

 

[learningstatistics]

That helps! Thanks a lot mikerickson.