Forum Discussion
Solved
Rearrenge column with 2 different types of data
I have a column that contains names and addresses. John Doe 123 Main St Miami, FL 12345 John Smith 456 Main St Miami, FL 67890 Paul Jhonson 789 MLK JR Blvd Tampa, FL 11121 I need name...
jai_v327 As a variant, consider WRAPROWS like this:
It also gives you three columns rather than two, but I believe that's even better. If you must have only two columns you can always join the second and third again.
jai_v327 As a variant, consider WRAPROWS like this:
It also gives you three columns rather than two, but I believe that's even better. If you must have only two columns you can always join the second and third again.