How to retrieve data column by column out of Excel workbook's individual sheet?

[Anonymous]

Dear Talend Masters, Savvys and Contributors:

Greeting from Henry, I am new to tdf 7.01 Big Data Platform
I wonder how to retrieve a Sheet from workbook (Excel) follow a vertical Column by Column manner instead of intaking row by row as Talend default (tFileInputExcel Component)?
I try to avoid manually pivot the sheet at the first place (avoid fat finger or other introduced mistakes) if there is a way by Talend.

[Anonymous]

I am think a workaround that in Excel use copy/paste's Paste Special "Transpose" functionality to make the 2 dimensional table make a 90' degree swivel. 
Also I am going to research the tFileExel-11.0, tUnpivotRow and tTranspose 3rd Component each individually,

since I am on the Talend Big Data v7.01 version, I doubt the tTranspose maybe outdated.

Also, I appreciate the fellow posts and contributors, you all together make this community GREAT

"In this article you will learn how to convert columns to rows."
ttps://community.talend.com/t5/Migration-Configuration-and/Converting-columns-to-rows/ta-p/21658

"Converting rows to columns"
https://community.talend.com/t5/Migration-Configuration-and/Converting-rows-to-columns/ta-p/21667

And Talend's online reference and tJavaRow, tJaveFlex,tPivotToColumnsDelimited, tNormalizer etc:
"How to extract data from specific Excel cells"
https://help.talend.com/reader/eh9WpFesWS~soEOr0cnHCQ/24sIK0IRjdl8EFpSFrYTXQ

As Talend's Eclipse backbone and Java-friendly, it's always can find a way to by t_Java, and Excel's native functionality as Paste "Transpose" : )
https://www.extendoffice.com/documents/excel/4602-excel-rotate-table-90-degree-180-degree.html