Skip to main content
Question

Excel advice on how to prepare excel to import into Multi Select field in QuickBase

  • April 6, 2017
  • 0 replies
  • 68 views

I currently have an excel sheet with recordID and Features columns
In the record ID I have the same number multiple times and in Features I have the different options.

To Import this into QuickBase, I need to join the Features rows with a ; in between

Red
Blue
Green

Red;Blue;Green in a single field so that I can import it into QuickBase

I have hundreds of records, each with 6 or 7 features.

Does anyone know of any tricks and tips to be able to speed up preparing the excel sheet?

Thanks in advance

Mick
This topic has been closed for replies.

  • Registered
  • April 6, 2017
Like this:

=A1 & ";" & B1 & ";" & C1