Row values as Headers

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.

Input sample.yxmd

Preparation

Accepted answers

binu_acs

@samxhander09 One way of doing this

Input sample.yxmd

All comments

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

@samxhander09 One way of doing this

Input sample.yxmd

samxhander09

@binu_acs Works fine! Thanks for the help!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703