How to transpose Rows to Columns in Excel?

Five Stars

How to transpose Rows to Columns in Excel?

Hi everyone,

 

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

 

Input:

Articoli561575
Video10491161
Tot16101736

 

Expected Output:

ArticoliVideoTot
56110491610
57511611736

 

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

Is it possible to achieve this output?

If yes, how?

 

Best regards,

Giacomo


Accepted Solutions
Five Stars

Re: How to transpose Rows to Columns in Excel?

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


All Replies
Fifteen Stars TRF
Fifteen Stars

Re: How to transpose Rows to Columns in Excel?

Four Stars

Re: How to transpose Rows to Columns in Excel?

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!

Five Stars

Re: How to transpose Rows to Columns in Excel?

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

And for "Aggregating functions"?

 

Thank's for the answer,

 

Giacomo

Fifteen Stars TRF
Fifteen Stars

Re: How to transpose Rows to Columns in Excel?

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

TRF
Five Stars

Re: How to transpose Rows to Columns in Excel?

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

Highlighted
Moderator

Re: How to transpose Rows to Columns in Excel?

Hello Giacomo,

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

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: How to transpose Rows to Columns in Excel?

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

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now