Welcome, Guest
Username: Password: Remember me

TOPIC: Response Codes with ID numbers

Response Codes with ID numbers 2 years 10 months ago #70706

  • ttophen
  • ttophen's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 9
  • Karma: 0
When we export data, we need to split question/answer data up and place them on different rows in a report. To do this we use an excel macro. What I need to know is if there is way to code every response with the ID of the person it belongs to so we have an extra insurance the answers belong to the correct ID?
The administrator has disabled public write access.

Re: Response Codes with ID numbers 2 years 10 months ago #70725

  • atiut
  • atiut's Avatar
  • OFFLINE
  • Senior Lime
  • Posts: 76
  • Thank you received: 2
  • Karma: 1
I would merge every response with the ID using formulas in EXCEl. As long as you are using 2007 or higher you should be fine.

LibreOffice might work too, but make sure that the last row is filled correctly. I have has some ugly surprises.
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.101 seconds
Donation Image