Join multiple column values into column(with line space) in excel and type that into webpage field with same line space

Help
1

My need is given below

  1. Having 3 columns in excel with multiple rows say for ex.
    col 1 col2 col3
    data base testing
    product base testing

now i would like to create one column say for col4 which should values like below
col 1 col2 col3 col4
data base testing col1
-------
data
col2
-------
base
col3
------
testing
(note: in the same cell)
the entire column 4(must have col1, col2, col3 values along with header) with same format i want to enter into webpage.

Please help me to resolve this.

2

@KavithaManivel,

  1. First use read range and it will give you output as DataTable

  2. Then iterate through using for each row
    assign index = DataTable.rows.indexOf(row)+2
    assign col4 = row(“col1”).toString + row(“col2”).toString + row(“col3”).toString
    take Write cell
    image

          Here, Range: D+index.toString
                Value: col4

Regards,
Lakshman Ganta.

3

Hi Lakshman,

Thanks for your immediate reply. But I am getting an error " object not set to an instance of an object"

4

@KavithaManivel,

Could you please send me the workflow and will check and let you know.

5

Iam new to the forum. May i know how to share the xaml

6

Click on reply and then header you can see one arrow icon to upload file.

7

Its not enabled to me . But i sent a private message to you.

8

got it

9

excelUpdated.xaml (14.4 KB)

This is the excel instead of CSV. Please help to fix this

10

@KavithaManivel,

I changed your workflow according to your requirement. Please find the attached workflow file and excel file.excelUpdated.xaml (12.0 KB)
New Microsoft Excel Worksheet.xlsx (8.6 KB)

Regards,
Lakshman Ganta.

11

Thank you so much. Let me check

12

Hi Lakshman,

Thank you so much. I was able to concatenate the string in one column. But i required along with the header also one by one in the same cell
col1
data
col2
base
col3
testing (in the col4)
will it be possible

14

I did not understand. Do you want like this or not ?

image

15

Hi Lakshman,

Thanks for your reply. I want along with header
say for example
col4

output should be in the column 4 given below
col1

data
col2

base
col3

testing
i was able to bring the line space but not header.