Ungroup column in rows

[rdr910]

I have one single column of information. I want to split this information in rows. The information consists of Name, Address, and city/st/zip. This is what it looks like nowuntitled.JPG

I want it to look like this: Name l Address l City/St/Zip



Can anyone please help?

[dilipandey]

Hi rdr910,

Look into the "Text-to-column" feature of Excel. Thanks.

regards,
DILIPandey

<click on below 'star' if this helps>

[dilipandey]

Hi Rdr910,

If you still have issues, would suggest you to post a sample file - not the image to enable forum to give a quick try. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>