Merged Columns in Excel from a Crosstab

[dmburke11]

I'm outputting a crosstab to excel and I want column A to repeat even when it's the same value (no merging.) Is it possible to force Excel to repeat the value in every row in a column even when they are duplicates? I am not grouping in the crosstab.

See attached example.

What I am getting is what you see in column A for "Actors" and what I want to see is "Baseball Players"

Any ideas?

Thanks everyone!

[Lynn]

I think I read that this is an option on running to Excel in version 10.2, but I am still on 10.1 so I can't confirm.

In the meantime, this is the method I use to achieve:
http://www.cognoise.com/index.php/topic,11363.msg37230.html#msg37230

Also, I think every good database design ought to have a crappy_indicator column somewhere :)

[dmburke11]

Thanks Lynn!

I will check out the post you linked to and report back if I'm successful.

(and yes, I like 'crappy indicators' :)  )