PDA

View Full Version : Combine multiple rows into one and then seprate specific columns



AHAD_BWP
09-25-2012, 03:45 AM
Hi All!

I have a sheet with multiple columns of data with multiple rows. I want to combine these multiple rows in to one and then separate only specific columns by text to column method by space deliminator.. I have attached both of sample sheet and a resulting sheet in 1 file

And hope you understand the question..

Thanks..

8826

parttime_guy
09-28-2012, 09:08 PM
Hi Ahad,

1 crazy formatting file ...but just wanted to solve it

Solution attached - read the instructions carefully

Hope u find this solution usefull.

Best regards :friends: