Row values as Headers

[samxhander09]

Hi community,

I tried using Transpose tool to make my rows values as new headers but I can't seem to make it happen.

What I want to output are two columns for Amount and Balance with the corresponding row values in original order from input. How could I possibly make that happen?

Attaching an input file, sample file only, public info.

[binu_acs]

@samxhander09 What is the expected result?

[samxhander09]

@binu_acs Thanks for replying. Something like the below

Amount  Balance
1.510   (28,959)
4          (1,125)
54        (380)
7890    (14,071)
715      (6,943)

[binu_acs · Accepted solution]

@samxhander09 One way of doing this

[samxhander09]

@binu_acs Works fine! Thanks for the help!