Capture column header when importing a list

JD_Nelson
Champion Moderator

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?

4 REPLIES 4
Rachel_Egan
Level 6

Re: Capture column header when importing a list

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.

Grégoire_Miche2
Level 10

Re: Capture column header when importing a list

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

-Greg

JD_Nelson
Champion Moderator

Re: Capture column header when importing a list

in case you all want to see it happen:

Grégoire_Miche2
Level 10

Re: Capture column header when importing a list

Voted