Power Query: Single cell with multiple values.

%3CLINGO-SUB%20id%3D%22lingo-sub-3274595%22%20slang%3D%22en-US%22%3EPower%20Query%3A%20Single%20cell%20with%20multiple%20values.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3274595%22%20slang%3D%22en-US%22%3EI%20have%20a%20worksheet%20with%20lots%20of%20customer%20information.%20One%20of%20the%20columns%20is%20the%20packages%20they%20have%20(can%20be%20diffrent%20for%20every%20customer).%20The%20format%20that%20is%20given%20is%20I01%20(letter%20number%20number).%20I%20need%20to%20take%20that%20and%20turn%20it%20in%20to%20the%20name%20of%20the%20package.%20Some%20of%20the%20packages%20are%20just%20getting%20deleted.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20table%20with%20two%20columns%20pkg%20code%20%2F%20pkg%20name.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20worksheet%20has%20a%20single%20column%20with%20the%20pkg%20codes%20seperated%20by%20a%20space.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20used%20the%20replace%20value%20but%20because%20some%20of%20the%20pkg%20are%20being%20deleted.%20It%20leaves%20a%20space.%3CBR%20%2F%3E%3CBR%20%2F%3EAll%20the%20packages%20can%20be%20separated%20into%203%20major%20categories.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20want%20to%20replace%20the%20pkg%20codes%20with%20the%20name%2C%20and%20then%20if%20they%20have%20the%20pkg%20but%20that%20name%20in%20to%20a%20column%20(3%20primary%20categories)%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3274595%22%20slang%3D%22en-US%22%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-3274794%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%3A%20Single%20cell%20with%20multiple%20values.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3274794%22%20slang%3D%22en-US%22%3EI%20will%20do%20that%20latter%20today%20when%20I%20get%20back%20home.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3274793%22%20slang%3D%22en-US%22%3ERe%3A%20Power%20Query%3A%20Single%20cell%20with%20multiple%20values.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3274793%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1351445%22%20target%3D%22_blank%22%3E%40Dedicated_J%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20you%20may%20illustrate%20by%20sample%20file%20how%20the%20data%20is%20actually%20structured%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
I have a worksheet with lots of customer information. One of the columns is the packages they have (can be diffrent for every customer). The format that is given is I01 (letter number number). I need to take that and turn it in to the name of the package. Some of the packages are just getting deleted.

I have a table with two columns pkg code / pkg name.

The worksheet has a single column with the pkg codes seperated by a space.

I have used the replace value but because some of the pkg are being deleted. It leaves a space.

All the packages can be separated into 3 major categories.

I want to replace the pkg codes with the name, and then if they have the pkg but that name in to a column (3 primary categories)
2 Replies

@Dedicated_J 

Perhaps you may illustrate by sample file how the data is actually structured?

I will do that latter today when I get back home.