How can I change the orientation of a row to a column showing sales in one row

[HeadBanger]

I need to transform the orientation of my data from displaying sales, units, margin by row into one single row.  Below is example.

Need to look like this 

[marcusblackhill]

Hey @HeadBanger !

You can use Crosstab tool from the transform group to do that job. 

[PhilipMannering · Accepted solution]

Hi @HeadBanger 

I would do the following,

1. Formula tool to concatenate Name and Target

2. Crosstab tool to get everything in a single row. No need for a group by any fields. Just have the header as your concatenated field and value as Value.

P

[HeadBanger]

Hi Philip,

You da man.  Thanks!  This worked.  I was missing that concat part for name and target.