One way to try ..

Assuming the source table below is in A1:D3

number option1 option2 option3
1234 X X
2345 X X
etc

Using empty cols to the right of the data

Put in E2: =IF(B2="X",$A2&"-"&B$1,"")
Copy E2 across 3* cols to G2
(*3 cols as there are 3 option cols)

Put in H2:
=OFFSET($E$2,INT((ROWS($A$1:A1)-1)/3),MOD(ROWS($A$1:A1)-1,3))

(The "3" in the OFFSET formula is equal to the number of option cols)

Select E2:H2, fill down until the last row of data in cols A to D

Put a label into H1, do a Data Filter Autofilter on it
& select: "(NonBlanks)" from the droplist in H1

Now just select and right-click copy all the filtered cells in col H
(those are the desired results) and then paste it elsewhere, say, in col A
in another sheet

Adapt to suit ..

For example, if there are say, 5 option cols altogether in cols B to F,

Put in G2: =IF(B2="X",$A2&"-"&B$1,"")
Copy G2 across 5 cols to K2

Put in L2:
=OFFSET($G$2,INT((ROWS($A$1:A1)-1)/5),MOD(ROWS($A$1:A1)-1,5))

Select G2:L2 and fill down. Rest of steps similar.

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Lynn Bales" wrote in message
...
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


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.