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
Highlighted
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
Highlighted
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

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.

What’s New for Talend Spring ’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

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch