Forum Discussion
Data Consolidation Help
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?
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
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?
- 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.