Hello Knime Users,,
I am looking to organize the same name from the different rows to one row with all other particulars. I meant to say instead of two rows, the same name resides in one row with all particulars. Please advise.
| RUN | CLIENTNAME | SCHEDTIME | PICKUPADDRESS | PICKUPADDRESSNAME | SPACETYPE | COMMENTS |
| 101 | Donald Duck | 6:15 | 16119 132 STREET NW. . EDMONTON | AM | ||
| 101 | Micky Mouse | 7:00 | 4480 MCCRAE AVENUE NW. . EDMONTON | ROSEDALE GREISBACH | XW | |
| 101 | Harry Potter | 7:00 | 4450 MCCRAE AVENUE NW. . EDMONTON | WC | ||
| 101 | Donald Duck | 10230 111 AVENUE NW. . EDMONTON | GLENROSE HOSPITAL | WC | Test | |
| 101 | Micky Mouse | 10425 111 AVENUE NW. . EDMONTON | ROYAL ALEXANDRA HOSP. (DIALYSIS) | XW | ||
| 101 | Harry Potter | 11111 JASPER AVENUE NW. . EDMONTON | GENERAL HOSPITAL (DIALYSIS) | AM | ||
| 101 | Mickey Mouse | 8:00 | 10127 121 STREET NW. . EDMONTON | PINNACLE | SC | |
| 101 | Range Horland | 8:15 | 9303 177A STREET NW. . EDMONTON | AM | ||
| 101 | Trump | 8:30 | 8027 179 STREET NW. . EDMONTON | AM | ||
| 101 | Clinton | 8:30 | 18206 97A AVENUE NW. . EDMONTON | WC | PROGRAM STARTS @ 10 AM | |
| 101 | Harry Potter | 16610 117 AVENUE NW. . EDMONTON | GOODWILL (SIGNUM PARK) | SC | ||
| 101 | Mickey Mouse | 9620 101A AVENUE NW. . EDMONTON | SALVATION ARMY | AM | ||
| 101 | Range Horland | 1 BONNIE DOON SHOPPING CENTRE. . EDMONTON | BONNIE DOON MALL NORTH WEST DOOR | AM | ||
| 101 | Trump | 1 BONNIE DOON SHOPPING CENTRE NW. . EDMONTON | BONNIE DOON MALL- BONNIE`S BAR & GRILL | WC | PROGRAM STARTS @ 10 AM | |
| 101 | Clinton | 9:45 | 7728 82 AVENUE NW. . EDMONTON | BETHEL SENIORS CITIZENS RES. | SC |