Moving data from one column to many

%3CLINGO-SUB%20id%3D%22lingo-sub-2355554%22%20slang%3D%22en-US%22%3EMoving%20data%20from%20one%20column%20to%20many%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2355554%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20sheet%20that%20has%20multiple%20pieces%20of%20information%20in%201%20column%20that%20needs%20to%20be%20separated%20into%20multiple%20unique%20columns%20in%20order%20to%20import%20into%20another%20system.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20information%20is%20not%20consistent%20in%20any%20way.%20It%20comes%20from%20database%20field%20that%20was%20just%20free%20form%20both%20in%20terms%20of%20info%20to%20capture%20and%20spacing.%26nbsp%3B%20In%20one%20column%20I%20can%20have%20name%20and%20company%2C%20and%20I%20have%20columns%20where%20where%20in%20addition%20to%20basic%20contact%20info%20there%20address%20and%20other%20information%20included%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20a%20convert%20to%20columns%20function%20does%20not%20work%20(well%20I%20suppose%20it%20could%20but%20still%20requires%20significant%20manual%20intervention)%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20other%20functions%2Fformulas%2Foptions%20are%20available%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2355554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2355933%22%20slang%3D%22en-US%22%3ERe%3A%20Moving%20data%20from%20one%20column%20to%20many%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2355933%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1054102%22%20target%3D%22_blank%22%3E%40KFilbert%3C%2FA%3E%26nbsp%3BWhy%20not%20upload%20an%20example%20of%20your%20%22inconsistent%20%26nbsp%3Band%20free-form%20data%22%20and%20explain%20how%20you%20would%20want%20to%20have%20it%20separated%3F%20Based%20on%20your%20question%20alone%2C%20I'm%20afraid%2C%20you%20will%20not%20get%20much%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have an excel sheet that has multiple pieces of information in 1 column that needs to be separated into multiple unique columns in order to import into another system. 

The information is not consistent in any way. It comes from database field that was just free form both in terms of info to capture and spacing.  In one column I can have name and company, and I have columns where where in addition to basic contact info there address and other information included 

So a convert to columns function does not work (well I suppose it could but still requires significant manual intervention) 

What other functions/formulas/options are available? 

1 Reply

@KFilbert Why not upload an example of your "inconsistent  and free-form data" and explain how you would want to have it separated? Based on your question alone, I'm afraid, you will not get much help.