Skip to main content
Community Advisor
Jul 13, 2016 5:56 PM UTC
Question

Capture column header when importing a list

I have some Q&A data in my spreadsheet that I need to capture to the notes field in marketo. The question is the column header and the answer is in the cell... but how do I get the header to map to the field too? I'd rather not have to concatenate everything every time if I can help it. Is there a way around this?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

4 replies

Level 6
Jul 13, 2016 11:24 PM UTC

I don't believe so. I think concatenating is the easiest way. In thinking about this issue, a few options came to mind but they were all more complex/time-consuming than a simple excel formula.

Translate
Grégoire_Miche2
Level 10
Jul 13, 2016 11:28 PM UTC

Rachel is right on this. Just do it with an Excel formula in you spreadsheet.

-Greg

Translate
JDNelson1Community AdvisorAuthor
Community Advisor
Jul 13, 2016 11:47 PM UTC

in case you all want to see it happen:

Translate
Grégoire_Miche2
Level 10
Jul 13, 2016 11:49 PM UTC

Voted

Translate