Aligning Data Automatically

Copper Contributor

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

2 Replies

@ThomasEinolf 

That could be like

image.png

@ThomasEinolf 

With the permission of everyone, here is an additional solution with pivot.

 

 

Thank you for your time and patience

 

NikolinoDE