SOLVED

Data Consolidation Help

%3CLINGO-SUB%20id%3D%22lingo-sub-2736379%22%20slang%3D%22en-US%22%3EData%20Consolidation%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2736379%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I%20am%20looking%20for%20help%20on%20how%20to%20consolidate%20data%20from%20multiple%20rows.%20My%20list%20includes%20members%20certifications%2C%20but%20are%20listed%20by%20certification%20and%20then%20by%20member.%20I%20am%20looking%20for%20a%20way%20to%20consolidate%20the%20info%20per%20member%20and%20if%20there%20is%20a%20way%20to%20auto%20do%20this%20rather%20than%20cut%20and%20paste.%20Thank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2736379%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%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2736530%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Consolidation%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2736530%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1151094%22%20target%3D%22_blank%22%3E%40SuzyQVT%3C%2FA%3E%26nbsp%3BNot%20sure%20how%20the%20file%20you%20uploaded%20relates%20to%20your%20question.%20The%20file%20contains%20a%20list%20of%20persons%20with%20their%20certifications.%20How%20would%20you%20want%20to%20%22consolidate%22%20this%20data%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2736606%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20Consolidation%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2736606%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BI%20attached%20as%20example%20for%20I%20can't%20post%20the%20real%20file%20I%20am%20working%20on.%20I%20want%20to%20consolidate%20the%20rows%20to%20show%20for%20each%20member%20their%20certifications%2C%20rather%20than%20listing%20as%20each%20certification.%20Does%20that%20make%20sense%3F%20The%20list%20I%20have%20right%20now%20is%20over%20200%20rows%20so%20this%20one%20is%20simple%20that%20I%20posted%2C%20but%20trying%20to%20be%20more%20efficient%20and%20know%20Excel%20has%20a%20feature%20to%20help%20me%20or%20would%20think%20they%20do.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello. I am looking for help on how to consolidate data from multiple rows. My list includes members certifications, but are listed by certification and then by member. I am looking for a way to consolidate the info per member and if there is a way to auto do this rather than cut and paste. Thank you in advance.

6 Replies

@SuzyQVT Not sure how the file you uploaded relates to your question. The file contains a list of persons with their certifications. How would you want to "consolidate" this data?

@Riny_van_Eekelen I attached as example for I can't post the real file I am working on. I want to consolidate the rows to show for each member their certifications, rather than listing as each certification. Does that make sense? The list I have right now is over 200 rows so this one is simple that I posted, but trying to be more efficient and know Excel has a feature to help me or would think they do.

@SuzyQVT Understand the confidentiality issue, but how would you want the output to look like?

hey thanks, i have attached a revised file showing below the initial date what i am trying to do. thanks for your help
best response confirmed by allyreckerman (Microsoft)
Solution

@SuzyQVT That helps!!

I'm a big fan of PowerQuery and it took less time to come up with a working solution that what it takes to write this response. See attached in the green table. Something you would want to consider learning?

Screenshot 2021-09-09 at 17.11.56.png

hey thanks, i didn't even think about that. thanks so much. I will look up some info online and do some training on it. really appreciate the help.