How to Transpose particular coloumn range to rows by assigning the same value to each

Hello Every one


The above image is my input data here i want to change it to this format like



If i use transpose things are not comming in a right way so can any one help me how to approach to the solution

here i am uploading the file
Project.xlsx (9.1 KB)

Hi @adarsh_kotagiri

You need to create a new data table, get the row item as item.array, and iterate from column D
then you need to use Add data row item activity to insert each record.

Hi @adarsh_kotagiri,

Please try this xaml:
ExcelTransMonth.xaml (10.1 KB)

Sample output: refer “Output” sheet
Project.xlsx (10.8 KB)



thank you sir

thank you soo much sir it really working

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.