How to transpose Rows to Columns in Excel?

[Anonymous]

Hi everyone,

I'm trying to transpose Rows to Columns of an Excel file.

Input:

Articoli	561	575
Video	1049	1161
Tot	1610	1736

Expected Output:

Articoli	Video	Tot
561	1049	1610
575	1161	1736

I tried unsuccessfully using tUnpivotRow, tNormalize, tDenormalize, tPivotToColumnsDelimited components.

Is it possible to achieve this output?

If yes, how?

Best regards,

Giacomo

[TRF]

Hi,

Here is a solution https://community.talend.com/t5/Migration-Configuration-and/Converting-rows-to-columns/ta-p/21667

Hope this helps.

[Anonymous]

Hey,

Would be easier if you included headings for your columns,
c1            c2        c3
Articoli    561      575
Video     1049     1161
Tot         1610      1736

I have used tPivotToColumnsDelimited that did exactly what you want, but it did take some tweaking for it to work properly.

The Pivot Column field should be c1, your Aggregate column would be c2.

That might work.

Goodluck!

[Anonymous]

And what should I put as "Group by" columns?

And for "Aggregating functions"?

Thank's for the answer,

Giacomo

[TRF]

The same as in the link should work.
Articoli for the "Group By", First for the Fonction.

[Anonymous · Accepted solution]

Hello everyone, 

unfortunately none of the solutions above worked.

By the way I found a custom component, tTranspose

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%...

This component works fine for the issue that I described.

Thank you all for the answers,

Giacomo

[Anonymous]

Hello Giacomo,

Thank for sharing your solution on forum and marked it as accepted.

Best regards

Sabrina

[Anonymous]

Tech Blog # Talend - Row to Column Transpose

Hey Guys! We have come up with a detailed blog on Row to Column Transpose in Talend.

Read it here - https://www.learningsutras.net/post/tech-blog-talend-transpose-rows-into-columns

For more blogs on Talend - Join us for FREE or Subscribe to our site www.learningsutras.net

#talend #learningsutras #techblog