Copy values from one excel to another

How to copy the Value of the each header in file 1 to file 2 ?

File 1:

image

File 2:

1 Like

Hi @Sathish_Kumar_S,

If you want the column A as header from file 1, follow the below steps:

  1. Use the read range activity to read the datatable
  2. Use the filter datatable activity to get the column A only
  3. Use transpose datatable activity
  4. Use write range activity to write the transposed datatable

Thanks & Regards,
Sanjit Pal

I don’t find “Use transpose datatable” activity in studio

1 Like

Hey @Sathish_Kumar_S

You want only the headers or the values as well ?

Thanks
#nK

1 Like

Hi @Sathish_Kumar_S ,

If you are looking for a dynamic approach, then here you go:


image
image

(From c In Enumerable.Range(1,dt_sampleData.ColumnCount-1)
Let rowItem = Enumerable.Range(0,dt_sampleData.Rows.Count).Select(Function(s) dt_sampleData.Rows(s)(c)).ToArray()
Select dt_result.Rows.Add(rowItem)).CopyToDataTable()

TransposeDataTable.xaml (8.2 KB)

Kind Regards,
Ashwin A.K

1 Like

2022-03-13_17h30_24

Only the Value from B8

1 Like

Hey @Sathish_Kumar_S

Could you please show output for this.

Thanks
#nK

1 Like