Something like this?

Note that you have to expose all attributes (all years).

Yes, thanks for taking the time to help me out with your response. The only difference from your solution is that, I need the years in rows and the weeks in columns, but I think I can follow your suggestions to have it as I want. I will keep you posted on my progress. Thanks again.

Ah yes, I see I misread your question a bit...

Thank you so much for taking the time again to provide me with the exact solution that I am looking for. I have attached a screenshot of my workspace and output from the AttributeExposer. My Week column labels all look like x.0. Any explanation for and how to fix this?

Hi, I am not sure, but I think the week numbers in your input are defined as numbers with decimals (also known as "real numbers").

If you are using FME 2023, you can set the data type in the AttributeManager.

In an older version, it may help to calculate the integer value in the AttributeManager.

Thanks a million for all the time you have spent helping me with my request and sharing your very useful knowledge. I appreciate your time and help immensely.