How to get multiple rows of 6 different groupings into one row and multiple columns

[sammyb84]

Basically one record is an input by each user.  I need to be able to display the data with up to 6 different groupings in one row.  I will attach an image to display. There could be up to 6 different 'Names' which I call Users.  In the example below there are only 5, so the 6th should be blank in those columns.  I've been unsuccessful at trying to append, union, cross tab, you name it.  

I should know this but I've been trying for too long and its just not coming to me.  Thanks for all you do community!

Current Data

Intended format

[MilindG · Accepted solution]

I guess one way to do it is by using Make Columns tool. Check out the workflow below.

[sammyb84]

@MilindG thanks for taking the time to post this.  This is a great tool to transform the data however, it doesn't seem to work if I want to have 6 users, in this case it would have left the 6th user info blank.  I'm thinking it needs to have a helper table to confine the 6 potential users.

The 'Make Columns' tool seems to only configure based on the data and when I change to 6 columns it moves Joe to the 6th column instead of the 1st User set of columns.  

[sammyb84]

@MilindG I went back an applied to my original data set and when grouped by another field this does seem to give me the result i'm looking for.  Thanks for the helpful tool.  I didn't see that one in my tool palate.  :) 

[MilindG]

@sammyb84  Yay, I'm glad it worked for you. I just learned about that tool not too long ago and its an awesome tool! 

Cheers!