I have address data in a file that looks like this:
First Last Name
Address Line
City State ZIP
First Last Name
Address Line
City State ZIP
First Last Name
Address Line
City State ZIP
First Last Name
Address Line
City State ZIP
I need to transform the data into a table format that looks like this.
First Last Name
| Name | Address | City_State_Zip |
| Joe Smith | 123 Anywhere Street | Anytown, CA 92103 |
| Debbie Hansen | 534 Anywhere Street | Anytown, WA 80329 |
| Henry Somebody | 485 Anywhere Street | Anytown, TX 54367 |
I can parse the City_State_Zip using Text To Columns, but I am struggling trying to just transform the data from label format to table. Help is appreciated!
