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

[AmritaUpadhyay]

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 

[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.

[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.