Following steps need to be performed in the analysis (before exporting to Excel) to avoid this issue:
1. Move the mouse to the right end of the person number column
2. There would be a pop-up menu displayed, from this menu select Column Properties
3. Click on Column Format tab
4. Under Value Suppression section, click on Repeat radio button
5. Save the analysis and view the results
6. Export to Excel and confirm whether the issue is resolved or not.
No comments:
Post a Comment
Please review my topic and update your comments
Note: only a member of this blog may post a comment.