Making Rows into Columns

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????

Example.xlsx

Workflow

Reporting

Output

Transformation

Accepted answers

binu_acs

@ewassell One way of doing this

Transpose_2504.yxzp

All comments

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.

Transpose_Crosstab_25042023.yxmd

binu_acs

@ewassell One way of doing this

Transpose_2504.yxzp

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!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703