Need Help Merging Every Other 6 rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2170351%22%20slang%3D%22en-US%22%3ENeed%20Help%20Merging%20Every%20Other%206%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2170351%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20merging%20every%20other%2012%20rows%20into%20one%20single%20cell%2C%20for%20example%20(1-12)%20(13-24)(25-38)%2C%20the%20data%20being%20merged%20is%20phone%20numbers%2C%20name%2C%20address%2C%20etc.%20There%20is%20a%20total%20of%2012%20per%20profile.%20I%20need%20something%20to%20automate%20the%20separation%20for%20each%20profile.%20I%20included%20an%20example%20using%205%20random%20data%20points.%20Notice%20how%20there's%20no%20separation%20from%20one%20profile%20to%20another.%20However%2C%20if%20I%20could%20find%20a%20way%20to%20separate%20every%205%20rows%20into%201%20cell%20they%20would%20all%20sort%20out.%20Thank%20you%20in%20advance%20for%20any%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2170351%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%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2170734%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20Merging%20Every%20Other%206%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2170734%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F980444%22%20target%3D%22_blank%22%3E%40JustNeedHelpWithThis1%3C%2FA%3E%26nbsp%3BDo%20you%20really%20intend%20to%20merge%20all%2012%20fields%20per%20profile%20into%20%3CFONT%20color%3D%22%23FF0000%22%3Eone%20cell%3C%2FFONT%3E%3F%20Possible%2C%20but%20perhaps%20you%20mean%20to%20transpose%20the%20fields%20so%20that%20you%20end%20up%20with%20%3CFONT%20color%3D%22%23FF0000%22%3Eone%20row%3C%2FFONT%3E%20and%2012%20columns%20per%20profile.%3C%2FP%3E%3CP%3EEither%20way%2C%20not%20very%20difficult%20with%20Power%20Query.%20Are%20you%20familiar%20with%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need help merging every other 12 rows into one single cell, for example (1-12) (13-24)(25-38), the data being merged is phone numbers, name, address, etc. There is a total of 12 per profile. I need something to automate the separation for each profile. I included an example using 5 random data points. Notice how there's no separation from one profile to another. However, if I could find a way to separate every 5 rows into 1 cell they would all sort out. Thank you in advance for any help.

1 Reply

@JustNeedHelpWithThis1 Do you really intend to merge all 12 fields per profile into one cell? Possible, but perhaps you mean to transpose the fields so that you end up with one row and 12 columns per profile.

Either way, not very difficult with Power Query. Are you familiar with that?