How to insert the data horizontally in excel.
Please check this topic.
You can try linq query as below or use nested loops, one for columns and other rows
in which activity it is used?
You can check the below post. You can use that custom activity to transpose. Or another method is there in the second post.