I am exporting Webform Submissions from one Drupal site and attempting to import them onto another site with Feeds.
Unfortunately, the "Select Options" Webform field (that allows for multiple options to be selected) looks like the following in the exported file.
I am attempting to import these results directly into Drupal with feeds. I wish for these to go into one List (Text) field called "Status Desired".
As you can see, these all have different headers and I want them all to go into the same field.
I tried to use the "Find replace" in Feeds Tamper to change the "X" to the correct value but I had no success.
For example, if the user selects all 4 of the options, only the last one is imported.
Is there any way for me to use Feeds Tamper to import this as is into Drupal?
Or will I have no choice but to modify the data in Excel?