I have a couple hundred rows. In column A their are multiple values sometimes separated with a comma, sometimes no delimiter at all. I need to separate what's in these cells and force them into new rows while having the other columns copy what's in each of those cells down into the newly created rows...
Hi there... and welcome to the Excel Forum. Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
Just before you submit your post, click on GO ADVANCED (near the bottom) and EITHER click "Manage Attachments" OR use the paperclip icon to open the upload window.
The paperclip icon
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks