I have data which consists of a row with an identifier and several columns
which are options for the identifier that contain an X when it's selected. It
looks like this

number option1 option2 option3
1234 X X
2345 X X

What I'm trying to get is a single column of

1234-option1
1234-option2
2345-option2
2345-option3

I've tried to use transpose and concatenate but it's a large spreadsheet so
it's still very manual. Any ideas or macros that would help me automate this
process would be VERY appreciated.