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

Help Activities
, , ,
1

Hello Every one
INPUT:

INPUT

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

OUTPUT:

OUTPUT

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)

2

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.

3

Hi @adarsh_kotagiri,

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

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

Thanks!

2 Likes
4

thank you sir

5

thank you soo much sir it really working

1 Like
6

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