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

1 ACCEPTED SOLUTION

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

6 REPLIES
Twelve Stars TRF
Twelve 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

Twelve Stars TRF
Twelve 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

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.