NameCurrencyTransaction 1Transaction 2Transaction3SonaliUSD870.33100020000SonaliEUR-119.24-3850512000 NameCurrencyAmountSonaliUSD870.33SonaliEUR-119.24SonaliUSD1000SonaliEUR-38505SonaliUSD20000SonaliEUR12000 Hello Everyone Posting to seek help here . First table represent the data that I have in raw file and Second table display the format in which I need my output. So basically I Need transactions present in three different columns in one single co Append or merge.xlsx

To bring data present in three different columns in one column one after another

Name	Currency	Transaction 1	Transaction 2	Transaction3
Sonali	USD	870.33	1000	20000
Sonali	EUR	-119.24	-38505	12000

Name	Currency	Amount
Sonali	USD	870.33
Sonali	EUR	-119.24
Sonali	USD	1000
Sonali	EUR	-38505
Sonali	USD	20000
Sonali	EUR	12000

Hello Everyone Posting to seek help here . First table represent the data that I have in raw file and Second table display the format in which I need my output. So basically I Need transactions present in three different columns in one single co

Append or merge.xlsx

Workflow

Help

Accepted answers

All comments

JosephSerpis

Hi @AmritaUpadhyay you can use a Transpose tool from the Transform Tool Category to achieve your desired results. You then may need a sort tool followed by a select tool to remove unwanted columns and rename fields.

Transpose_18032024.yxmd

AmritaUpadhyay

Hi @JosephSerpis Thanks for this solution But while applying this my records are getting duplicate. Any idea who can we rectify this.

AmritaUpadhyay

Hi @JosephSerpis Thanks for this solution But while applying this my records are getting duplicate. Any idea who can we rectify this.

aatalai

@AmritaUpadhyay try the unique tool, or if it is possible to have an example of starting data that causes duplicates as @JosephSerpis should work fine

AmritaUpadhyay

I am having 30 records but after transposing I am having 240 records.

cjaneczko

You can use the Arrange tool for this.

aatalai

In the initial example you had 2 records and then had 6, so I would expect number of records to increase after a transpose

cjaneczko

If you need to preserve the sort order you can use this one.

To bring data present in three different columns in one column one after another.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703