Moving Columns to Rows

[MattR79]

I am trying to rearrange some columns and rows and cannot figure out how to get to the layout I want, I have tried crosstab/transpose and arrange, but I can't get the correct layout.  To be honest I don't have a great grasp on how the arrange tool works so it may do what I want but i cannot figure it out.  In the file attached below you can see my current layout which has the aging bucket with current day and prior day buckets in columns next to each other.  The issue here is that in the email format it gets very hard to read as the columns get narrowed quite a bit.  What I would like to do is to take all of the prior day columns and insert them in rows under each user.  I also want to only use the current day rows as inputs for the total and % of total rows.  Thanks in advance for any help you can give me in figuring this out.

[CoG · Accepted solution]

I'm not sure exactly how you are putting together your data, but I have used the "Arrange" tool like this to get most of what you are describing done. Other fields can be added in after the fact for display purposes.

[cjaneczko]

I am not sure what the relationship is between user and PD, but I was able to get the data to look the way you want. It takes some serious gymnastics though. Take a look at the following.

[MattR79]

Thank you!  That worked perfectly, it really did just come down to me not understanding how the arrange tool worked.  This will definitely help me down the line as well.