Reaching out for help after many attempts. I dont think text to columns will work in this situation, but not sure
A2 = Name
A3 = Street Adress
A4 = City, State and Zip
A5 =Then a blank row
A6 = Name
A7 = Street Adress
A8 = City, State and Zip
And so on..
I need to make labels and this format is not going to work.
Unfortunately I have many people in column A, so I am not sure if we can get this.
I would like
Name in Column A
Street address in column B
City State and Zip in Column C
A2 = Name
A3 = Street Adress
A4 = City, State and Zip
A5 =Then a blank row
A6 = Name
A7 = Street Adress
A8 = City, State and Zip
And so on..
I need to make labels and this format is not going to work.
Unfortunately I have many people in column A, so I am not sure if we can get this.
I would like
Name in Column A
Street address in column B
City State and Zip in Column C