Trasform one row in a column in a csv file, and concatenate all the columns into one column

[AlessandraBianco3266]

I have a csv file (see the foto below)

the second row must become a column (Gen, Feb, Mar ...)

and I want to concatenate all the columns into one column:

0.0

0.2

0.4

.

.

.

6.4

11.2

12.4

6.2

.

.

.

6.0

etc

this is the csv file :

in talend i create metadata > FileDelimited :

this is how i would like the output:

Day | Mouth | Year | Daily_Data | Station

1 | Gen | 2014 | 0.0 | SGemini

2 | Gen | 2014 | 0.2 | Sgemini

3 | Gen | 2014 | 1.4 | Sgemini

... and so on, for all day ....

31 | Gen | 2014 | x | Sgemini

1 | Feb | 2014 | 11.2 | SGemini

2 | Feb | 2014 | 12.4 | SGemini

...

...

1 | Dic | 2014 | x | SGemini

...every day of December

31 | Dic | 2014 | x | SGemini

can you help me please?

[Anonymous]

Hi

Can you provide an example for testing?

Regards

Shong