Jul 15 2021 09:40 AM
Hi there,
I am trying to align data in a certain way so that I can run formulas through excel. For the work that I am trying to do, there are a lot of individuals with data next to each of their names. I have an example attached for what is given and what my goal is for this project. I understand that I could copy and transpose paste. However, I am working with over 1000 names so this would take way too long
Jul 15 2021 10:12 AM
Jul 15 2021 10:25 AM
With the permission of everyone, here is an additional solution with pivot.
Thank you for your time and patience
NikolinoDE