Assigning values to a set number of cells

%3CLINGO-SUB%20id%3D%22lingo-sub-901696%22%20slang%3D%22en-US%22%3EAssigning%20values%20to%20a%20set%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-901696%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20a%20formula%20that%20will%20take%20a%20data%20that%20has%20values%20assigned%20to%20them%20and%20arrange%20it%20on%20set%20up%20cells%20in%20order.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EExample%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eq%20-%207%3C%2FP%3E%3CP%3Ew%20-%204%3C%2FP%3E%3CP%3Ee%20-%206%3C%2FP%3E%3CP%3Er%20-%208%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20it%20to%20read%20that%20and%20then%20arrange%20in%20cells%20in%20a%20set%20range%20of%20cells%20(lets%20say%2016%20x%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CLI-EMOJI%20id%3D%22lia_smiling-face-with-sunglasses%22%20title%3D%22%3Asmiling_face_with_sunglasses%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%207%20cells%20with%20a%20q's%2C%20then%204%20cells%20with%20a%20w%2C%20then%206%20with%20an%20e%2C%20etc.%20Is%20this%20even%20possible%2C%20I%20feel%20like%20it%20is%20but%20cant%20figure%20it%20out.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-901696%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-904304%22%20slang%3D%22en-US%22%3ERe%3A%20Assigning%20values%20to%20a%20set%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-904304%22%20slang%3D%22en-US%22%3Esounds%20interesting%20but%20I%20couldn't%20figure%20out%20what%20exactly%20you%20need.%20Also%20looked%20at%20the%20file%20but%20I'm%20still%20struggling%20to%20understand%20the%20requirement.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-906868%22%20slang%3D%22en-US%22%3ERe%3A%20Assigning%20values%20to%20a%20set%20number%20of%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-906868%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422787%22%20target%3D%22_blank%22%3E%40aworral0811%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recommend%20that%20you%20manually%20enter%20your%20desired%20results%20and%20explain%20the%20logic%20thereof.%20It%20is%20such%20logic%20that%20dictates%20the%20formula%20to%20return%20your%20desired%20results.%20Needless%20to%20say%2C%20you%20won't%20obtain%20any%20suggested%20formula%20without%20your%20explanation%20of%20the%20logic%20of%20your%20desired%20results%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I need a formula that will take a data that has values assigned to them and arrange it on set up cells in order.  

Example:

 

q - 7

w - 4

e - 6

r - 8

 

I need it to read that and then arrange in cells in a set range of cells (lets say 16 x   7 cells with a q's, then 4 cells with a w, then 6 with an e, etc. Is this even possible, I feel like it is but cant figure it out. 

 

Any help would be appreciated! 

2 Replies
Highlighted
sounds interesting but I couldn't figure out what exactly you need. Also looked at the file but I'm still struggling to understand the requirement.
Highlighted

@aworral0811 

I recommend that you manually enter your desired results and explain the logic thereof. It is such logic that dictates the formula to return your desired results. Needless to say, you won't obtain any suggested formula without your explanation of the logic of your desired results,