I want to add data that I have scraped using GetText from a FakeNameGenerator.
I then want to add this data to specific columns in an empty excel file.
Columns: Name Address Number
I have successfully scraped the data but when I try to insert it to the excel file all the data ends up under the first column. But I want the scraped variable “name” to end up under column Name, variable “address” under column Address etc…
How it looks now:
How do I assign the specific data to each column?
I have created a Data Table using “Build Data Table” and set the columns, after that I tried using a For Each Row with a Write range but it doesn’t work.