Form with pipes handler

I’m trying to display in the data base the “department” name for email address choices.

[select* menu-group “Department 1 | email1@domain.com” “Department 2 | email2@domain.com” “Department 3 | email3@domain.com”]

Currently the database only shows email1@domain.com under “menu-group” but I’m trying to get two columns. One would be menu-group with Department 1(2 or 3) and the other would be menu-group_email with email1@domain.com(2 or 3).

I’ve installed Shortcodes, Actions and Filters plug-in and used the functions as described on this post http://cfdbplugin.com/?page_id=804

Everything submits okay but I’m not getting the separated columns. Any help would be greatly appreciated.

https://wordpress.org/plugins/contact-form-7-to-database-extension/