Transpose using Power Automate

For doing  Transpose using power automate first we need to understand how we transpose in excel.

To transpose data in Excel, we follow these steps:

1. Select the range of cells you want to transpose.
2. Right-click the selected range and choose “Copy” or press Ctrl + C to copy the data.
3. Right-click on the cell where you want to start the transposed data and choose “Paste Special” or press Alt+h+v+t keys together.
4. In the Paste Special dialog box, check the “Transpose” option and then click “OK.”

This will transpose the selected data into the new location.

Steps to Transpose using power automate

Similarly In Power Automate Desktop go to actions

1.Launch Excel

2. Copy cell from Excel worksheet

3. Launch Excel where you want to paste transpose date.

4.Send Keys in Send keys connector text to send enter {Alt}({H}{V}{T}).