Hi @Vivek Pandile,

Try the below method

• Create an Entity: First, create an entity (e.g., NumberData) with an attribute like Number to store the data.

• Create a Screen/Action: In your screen or action, create a local variable of type List of NumberData to hold the rows you want to transpose.

• Fetch the Data: Use an aggregate to fetch all rows from NumberData into a list.

• Transpose the Data: Use a ForEach widget to loop over the list and group every N items (e.g., 5 items per group). You can create a new list for each group (row) and store these lists in a separate variable.

• Display the Data: On the screen, loop through the newly created lists (columns) and display them as needed, like in an HTML table.

Hope this works.

Thanks,

Senthil

Dear @Vivek Pandile 

Please enahnce the question so that folks here can answer :)
1- Attach the source excel  or share a snap of data from it
2- You want data to be organized whithin an output excel or show on UI ?


Ref for future:
https://www.outsystems.com/forums/discussion/15571/how-do-i-ask-a-good-question/

Good Luck