Excel Pivot Table Row Section Drop Down List

[valdosta]

Hi, the row section in an Excel pivot table, which reads data from an Access table, looks like below:

Sex (drop down list)
F
M
(blank)

How can I change it to the follwoing without changing Access table:

Sex (drop down list)
Female
Male
Missing Data

Thanks in advance!

 

[psimon1]

Hmmm....I'm sure that you can do it with vba but try this.

Export the data to Excel and then record a macro for three find and replaces. Then select all of your data and you should be set to go. Of course, you'd have to run the macro each time.

 

[valdosta]

Thanks, psimon1!

It works!!!