Transform Excel column to row

Transform Excel column to row

  

Dear Experts,

 I need a help on Excel transformation.

I have an excel like:

Date/Item code

A

B

C

D

Jan/11
1.02
1.02
1.02
1.02
Feb/11
0.2
0.2
0.2
0.2
Feb/18
0.4
0.4
0.4
0.4
Mar/18
0.6
0.6
0.6
0.6






where no of column is not fix, I want to transform column to row like

Month/Date
Item-code
Price
Jan/11
A1.02
Feb/11
A0.2
Feb/18
A0.4
Mar/18
A0.6
Jan/11
B1.02
Feb/11
B0.2
Feb/18
B0.4
Mar/18
B0.6
Jan/11
C1.02
Feb/11
C0.2
Feb/18
C0.4











Is there any easy solution to do that.

I can do it in each loop.


Thanks In Advanced.

Hi Ritesh,

The best solution to your case is use the forge component Advanced Excel.  It is possible to access your sheet with this component using the row and column index , so you can iterate you spreadsheet and create your data as you need.  

https://www.outsystems.com/forge/component/355/advanced-excel/

Best Regards

Fabio Fantato


Fantato wrote:

Hi Ritesh,

The best solution to your case is use the forge component Advanced Excel.  It is possible to access your sheet with this component using the row and column index , so you can iterate you spreadsheet and create your data as you need.  

https://www.outsystems.com/forge/component/355/advanced-excel/


Best Regards

Fabio Fantato



Thanks Fabio, but there is no documentation??? and dont know, how to read data from xls sheet..