How to transpose Export to excel data rows -> column to Column -> rows.

0
Hello All.   Just I have a clarification like In the Excel import how can we transpose the excel data column to row. Here Amount and Due date is dynamic based on user selection month it may be 12 months or may be 16months    Actual Import the data like this   Sample excel data:            A                     B                     C                       D                   E                          F                     G 1     Product          Amount        Due Date        Amount        Due Date            Amount        Due Date .............................................................................................................................................................................. 2     BMW            100000        4/10/2021          100000        5/10/2021        100000        6/10/2021 3     Audi               50000        4/10/2021             50000        5/10/2021        100000        6/10/2021   Needed to transpose the excel like below.              A                   B                      C      1     Product        Amount        Due Date        ................................................................... 2     BMW            100000        4/10/2024             3                           100000        5/10/2024             4     Audi              100000        4/10/2024             5                           100000        5/10/2024                          Is there any option to transpose like this. Is there any customized Java action for the above mentioned transpose 
asked
1 answers
0

Hi,

I have recently used the Advanced Excel module for this kind of use case and it works great!  You could give that module a try.  Here is a link to this module:  https://marketplace.mendix.com/link/component/116370

Hope that helps,

Mike

answered