I'm new to excel macros and I'm trying to create a sheet to summarize
another one. The sheet with the data is setup like is:
Col1 Col2 Col3
R1 x
R2
R3 x

Where an x exists I want to copy column and row names into the second
sheet, so it would show:
R1 Col1
R3 Col2

Now I could go about this manually, but I'm looking at 245 rows and 2
dozen columns and a automated solutions would be a lifesaver.

Any help would be greatly appreciated!

Thanks,
Brian