Skip to main content
Known Participant
Mar 3, 2023 8:15 AM UTC
Question

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!!

    1 reply

    Inspiring
    Mar 3, 2023 2:49 PM UTC

    AFAk I don't think we can do this in Appian