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

Question

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

_anomdiebolt_ · Answer

Like this:=A1 &amp; ";" &amp; B1 &amp; ";" &amp; C1

michaelgraham2 · Answer

It looks like I would have to type in that for each record. &nbsp; Ive got 2000 records.I could just as well export it them to a text file and manually add the ; between the text :(

quickbasecoachd · Answer

man o man. &nbsp;Just copy the formula down 2000 rows. &nbsp;Edit Copy. Highlight the 1,999 cells below. Edit Paste.

_anomdiebolt_ · Answer

Just pull down on the handle for 2000 rows:

michaelgraham2 · Answer

Record ID &nbsp; Feature1 Red1 Blue1 Green1 Yellow1 Pink1 Gray2 Yellow2 Brown&nbsp;2 Red1 &nbsp;Red;Blue;Green;Yello;Pink;Gray2 &nbsp;Yellow;Brown;RedThats what I need to achieve. &nbsp;I cant see how copying the formula down is going to acheive that??

Forum Discussion

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

Related Content

Three Words of Advice on Pipelines

Three Words of Advice on Building Pipelines - Brittany Scheid

QuickBase Scripts

Subject: Seeking Advice for Inventory App Design in QuickBase

Quickbase App Issues