Hi Talend Folks,
Talend and similar ETL tools are very much about dealing with fixed, structured data, and the standard components are geared up for this.
In this case, there are presumably a dynamic number of columns, and the column headings are going to change, which means these standard components and standard approaches aren't suitable.
As I've explained in your other thread regarding the column names in Talend, you also won't be able to use the dates in your spreadsheet as columns within your job.
Assuming you can't just pivot this in Excel itself, which is very quick and easy to do, then you will either require custom code in a tJavaFlex component, or maybe a custom component.
Take a look on Talend Exchange (https://exchange.talend.com/) and see if there's something suitable.