Hello, tried searching and had no luck, I have a list of 2,500 rows that have a patients name and a corresponding diagnosis, I need to create single rows for each patient name and then have their diagnosis displayed in separate columns within that row but there are differing numbers of diagnosis' for each patient. Some may have 4 some may 8 and some have 1 no rhyme or reason to the list. Any suggestions are welcome! If VBA is the only way that's fine but I'm hoping a formula will do it as I need to share the solve and we block macros.
Thanks!
Example attached.