List To Table Issue

[firefox29 0]

I'm unable to scrape a website table using "scrape a table" so I used "add list to list" with "scrape attribute".

I'm able to get the data I want this way but it list it like this:

 

Row: 0

Name

Address

Company

 

Row 1

Name

Address

Company

 

 

When I would like it to be in a table format like this:

Column 1: Name

Column 2: Address

Column 3: Company

 

So I can export it with the information listed across the excel page via Columns and not down the page in rows.

 

Any help will be greatly appreciated.

Edited January 20, 2016 by firefox29

[pash 504]

use command

1. add list to table

2. remove col 0

or

1 remove list first potion

2. add list to table

[HelloInsomnia 1103]

Here is an example of what I think your problem is and a solution:

clear table(&table)
set table cell(&table,0,0,"Name
Address
Company")
set table cell(&table,1,0,"Name2
Address2
Company2")
set table cell(&table,2,0,"Name3
Address3
Company3")
set(#row,0,"Global")
clear table(&result)
loop($table total rows(&table)) {
    clear list(%table_cell)
    add list to list(%table_cell,$list from text($table cell(&table,#row,0),$new line),"Delete","Global")
    add list to table as row(&result,#row,0,%table_cell)
    increment(#row)
}