Transposing groups of columns into multiple rows

[blitzmonkey]

Hello!  I am a relatively new user and I am trying to do some self-practice.  Currently, I have a data set that has a State listed and then in the same row, has a rank from 1 to 10 of some names followed by a sum amount of those ranks in the same order followed by a percentage in those ranks in the same row. 

For example.   AZ   Company A   Company B  Company C  1000  900  800   60%  30%  10% 

What I want to do is transform it so it says this:

AZ Company A  1000 60%

AZ Company B 900  30%

AZ Company C  800 10%

How could I accomplish this?

Thanks!

[binuacs · Accepted solution]

@blitzmonkey One way of doing this with the Tile tool

[blitzmonkey]

Would I do anything different if there were multiple states?  

Oh, I got it.  I just cleansed the data first.  There were some Null/ NA fields causing issues.