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!
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 :)
Thanks Lynn!
I will check out the post you linked to and report back if I'm successful.
(and yes, I like 'crappy indicators' :) )