Separate in 2 columns 1 column of information

Help Studio
, ,
1

I am extracting a set of information with screen scraping and then converting it to a data table. This give me an output of 1 column, but I need the info to be in 2 columns. Any idea ?

Example of extracting data:
Vendor Name
Pens n Pencils
Street Name
3046 Pyramid Valley
City
North Liberty
Country
United States
ZIP Code
52317
Telephone
202-022-1674
Email ID
felix.dolan@pnp.com

Output needed:

image

2

Try this using write cell Formula (Note: you should be using latest version of excel)

1 Like
3

@deni_cr95
Using the Extract Table Data activity, you select the data and name the columns by adding each.

Regards

1 Like
4

This was a great solution! Thank you so much!

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.