Making Rows into Columns

[ewassell]

I feel like this should be easy but I can't for the life of me get the Cross Tab or Transpose tools to work the way I want them to. I have 4 rows (sometimes more, sometimes less) depending on the First, Last Name and Contractor Invoice #.  I want everything on the same row for them.  Here is an example of what I'm trying to do. First 5 rows is how it looks now.  Row 9 and 10 are what I want it to look like.  Is this possible?  How????  

[JosephSerpis]

Hi @ewassell you would need use a combination of Transpose and Crosstab tool and use the group funcationality in both of these tools for some of your fields to achieved your desired results. I mocked up an example with resembles your desired output.

[binuacs · Accepted solution]

@ewassell One way of doing this

[ewassell]

Thanks @JosephSerpis  but I'm not seeing the actual new columns. I don't want a sum, I want the columns with the current amounts in them.  Is this possible?

[JosephSerpis]

Hi @ewassell can you claify what you mean you don't want a sum as an example you have 4 rows for Bill Total which the total equals 1876.07 and is the number in the desired output which the approach shown will provide?

[ewassell]

Thanks so much!!!

[ewassell]

Thanks everyone!