Transpose data in excel

Hi All

I am working on version 22.3.

My requirement is to get data from DB and provide it to user in excel format. This I have achieved using OOTB node "Export Data Store Entity to Excel". The excel sheet obtained looks something like below:

However, I want to transpose the excel data as below:

Can anyone please suggest how is the above achievable.

Thanks in advance!!

  Discussion posts and replies are publicly visible