Spreadsheet: 786130d1657006286-converting-columns-into-rows-with-different-values-pq-columns-to-rows-extraction-aligw
Sheet: PQ Columns to Rows AliGW

Before
First Name | Last Name | Street Address | City | State | Zip | Mail Street Address | Mail City | Mail State | Mail Zip | Landline | [NAME] | Landline 22 | Landline 23 | Landline 24 | Landline 25 | Landline 26 | Landline 27 | Landline 28 | Landline 29 | Landline 3 | Cell | Cell 2 | Cell 3
Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | 9046834171 | 9043530804 |  |  |  |  |  |  |  |  | 9046196326 | 9049013007 | 9043764193 | [PHONE]
[NAME] | Altenberg | 8989 [NAME] | Jacksonville | FL | 32210 | [NAME] 59 | Santa Monica | CA | 90406 | 3108237476 | 3236601858 |  |  |  |  |  |  |  |  |  | 3109909252
Roehl | Armante | 8673 Star Leaf Rd N | Jacksonville | FL | 32210 | 2714 Fairlane Pl | [NAME] | CA | 91709 | 9096282123
After
Column1
First Name | Last Name | Street Address | City | State | Zip | Mail Street Address | Mail City | Mail State | Mail Zip | PHONE |  | First Name | Last Name | Street Address | City | State | Zip | Mail Street Address | Mail City | Mail State | Mail Zip | Attribute | Value
Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | 9046834171 |  | Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | Landline | 9046834171
Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | 9043530804 |  | Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | [NAME] | 9043530804
Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | 9046196326 |  | Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | Landline 3 | 9046196326
Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | 9049013007 |  | Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | Cell | 9049013007
Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | 9043764193 |  | Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | Cell 2 | 9043764193
Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | 9045170384 |  | Veronica | Adams | 2585 [NAME] | Jacksonville | FL | 32210 | 1317 W 20th St | Jacksonville | FL | 32209 | Cell 3 | 9045170384
[NAME] | Altenberg | 8989 [NAME] | Jacksonville | FL | 32210 | [NAME] 59 | Santa Monica | CA | 90406 | 3108237476 |  | [NAME] | Altenberg | 8989 [NAME] | Jacksonville | FL | 32210 | [NAME] 59 | Santa Monica | CA | 90406 | Landline | 3108237476
[NAME] | Altenberg | 8989 [NAME] | Jacksonville | FL | 32210 | [NAME] 59 | Santa Monica | CA | 90406 | 3236601858 |  | [NAME] | Altenberg | 8989 [NAME] | Jacksonville | FL | 32210 | [NAME] 59 | Santa Monica | CA | 90406 | [NAME] | 3236601858
[NAME] | Altenberg | 8989 [NAME] | Jacksonville | FL | 32210 | [NAME] 59 | Santa Monica | CA | 90406 | 3109909252 |  | [NAME] | Altenberg | 8989 [NAME] | Jacksonville | FL | 32210 | [NAME] 59 | Santa Monica | CA | 90406 | Cell | 3109909252
Roehl | Armante | 8673 Star Leaf Rd N | Jacksonville | FL | 32210 | 2714 Fairlane Pl | [NAME] | CA | 91709 | 9096282123 |  | Roehl | Armante | 8673 Star Leaf Rd N | Jacksonville | FL | 32210 | 2714 Fairlane Pl | [NAME] | CA | 91709 | Landline | 9096282123
Roehl | Armante | 8673 Star Leaf Rd N | Jacksonville | FL | 32210 | 2714 Fairlane Pl | [NAME] | CA | 91709 | 9096280000