Sep 09 2021 06:44 AM - edited Sep 09 2021 07:58 AM
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.
Sep 09 2021 07:35 AM
@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?
Sep 09 2021 07:49 AM
@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. :)
Sep 09 2021 07:54 AM
@SuzyQVT Understand the confidentiality issue, but how would you want the output to look like?
Sep 09 2021 07:59 AM
Sep 09 2021 08:13 AM
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?
Sep 09 2021 08:46 AM
Sep 09 2021 08:13 AM
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?