I would think an AttributeExploder would do most of what you want.

Takashi's answer in https://knowledge.safe.com/questions/65491/passing-a-table-to-the-attributeexploder-but-keepi.html is a good starting point.

@dkus2001 Are the source column names always consistent?

Hi Robotix,

Thanks for answering. Those are headers that are going to be changing because they are dates. But I am happy if I can arrive to an answer on how to do it. I have played with the exploder but to be honest after long hours I have not come to a way to do it. I am not an expert.

Thank you jdh for answering. I will try to play with that.

@dkus2001

DenormalizeExcel_Example.fmw I just had the same issue but my columns were static. Find the solution in the attached.

You would have to refresh your reader and re-select the columns but this may help you down the path. I created a simple spreadsheet with your example. Then I fed it in and selected the relevant columns in the attribute keepers.

This may give you a better idea of how it works.

Robotix,

Than you SO MUCH for the time you devoted to the answer. IT IS SO VERY APPRECIATED..!! I will try I will go back. Many Many Thanks..!!

When I said I was going to test I meant understand. I am pretty sure that it works. You are so talented..!!

Robotix

Thank you very much for your. It works perfectly as expected. Again I am very grateful for your help and time...!!!

One day I might know half of what you know..!!

:-)

That's great! Glad I could help out.