Create 1 "Amount" Column Instead of a "Hours" and "Lines" Column

[jrubin]

Hello,

I am trying to create 1 amount column instead of having 2 so it can be easily pivoted. Currently I have a "Lines" and "Hours" column with the amounts in them. What I want to have is 1 "amount" column and then create a different column that states whether the amount shown is "Lines" or "Hours". This could be called "Measure Category" or something like that.

Thanks.

Jared

[BrandonB]

Hi @jrubin 

You will want to give the transpose tool a try. This will reorient your data from a lines and hours column into one column that indicates if the row is lines or hours and the second column with the value. 

[BrandonB]

 

[jrubin]

This works, thanks Brandon!