Creating a list in a Column using Data Scattered in Different Cells
This thread is kind of an extension to the below thread
Russell Dawson I did try you suggestion but since my data had mixed delimiters it didn't work as expected so I used Marcol's Formula which I found was very useful and easier for me. Even Haseeb's would have worked if i had only <Space> OR <Space>
So thank you all for the support and guidance.
My current problem is that I have the data as per Marcol's Formula and now I need the keywords to be arranged in a Single Column, again the data is voluminous so can't do it manually
Thanks in advance for all the support
Last edited by veejar; 05-27-2012 at 03:49 PM.
Re: Creating a list in a Column using Data Scattered in Different Cells
Using your posted workbook...
This regular formula lists each source range item, in order: left-to-right, top-to-bottom:
Copy that formula down as far as you need.
These are the first 10 results:
Is that something you can work with?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1