Hi
Can someone help me how to duplicate all rows on an excel file, then place the duplicate data below each row?
For example, this is the input file:
Then the final output should look like these:
Hi
Can someone help me how to duplicate all rows on an excel file, then place the duplicate data below each row?
For example, this is the input file:
Then the final output should look like these:
Dear @AE_Knights - could you please answer?
An approach is to read the same excel file through 2 flows and merge the data. Then sort on the key value you would like to organize the sequence.
Make sure the format of fields is the same. Best, create the Excel input and duplicate. Then join through a step.
Hope this helps.