How to copy column into row (transpose)

excel
activities

#1

I’m looking for a way to do the following;

  1. Copy specific range of column (G5:G61) from Excel file “1”
  2. Paste it to specific range of row (A6:AS6) in Excel file “2”

#2

Update small change: This is non programmatic approach. Open excel scope, follow below hot key pattern

  1. F5 (src start range)
  2. f5( src end range)
  3. Shift + enter(will select range)
  4. ctrl+c( copy src range)
    Alt+f4(close excel1)
    Open excel2
    5)f5(dest start range)
  5. Alt+Ctrl+V (opens pop up)
  6. E (select transpose)
  7. Enter
    9)ctrl+s (save excel)

#3

I am sorry but I am unable to follow this approach.Could you please attach a template xaml file. Would be of great help.


#4

Hi @Yama,

Instead of copy/paste you can go for another approach,
Use Read range activity to get the data
use write range activity to write the data.

Regards,
Arivu


#5

Ignore the logic, use this.This is for complete excel transpose.

excel_horizontal.xaml (15.2 KB)


How to exchange excel data columns to rows with out using data table (i.e Transpose)?
Reading Data With Vertical Header From Excel to DataTable
#6

But what if 2 rows have a common row name. For eg:


the answer I get is without the ids

and the main “Name” header is in one of the cells.
How do I add the ID column and Merge the two cells to write the “Name”


#7

Hi,
Please help me in transpose the particular columns to rows.

The sample input data is shown below,

The required/desired output is shown below,

Please help me! Thanks in Adance


#8

Hi @Sanjna

try this.
Transpose.xaml (14.7 KB)
New Microsoft Excel Worksheet.xlsx (9.1 KB)

Regards,
venkatesh.


#9

@Venkatesh_Chowdary,
Thanks!
But could you please take a closer look at the output pattern we require. There is repetitive entry based on the SA month, we want the output in such away.