I need to organize a structure of a huge xlsx file with data collected in a single column. This is a company list, Company names have a bit different formatting, so may someone can use it to help me. Also I need to start a new line when the same company has more than one address.
You can see the source and desired output in the attached xlsx file. Please find attached file with 2 tabs: Issue and Result I want to achieve
I guess it can be done using some VBA or excel formula.
Many thanks if anyone can help me.
Processing data from one column in excel
-
aidarko -
August 31, 2016 at 8:25 AM -
Thread is marked as Resolved.
-
-
-
Re: Processing data from one column in excel
You need to carefully re-do that sample. 14 (Phone2) has been assigned to both Company1 & Company3 and c (Phone2) is shown under Company1 in the results when it is listed under Company2 in the sample - if those happen to be correct then you need to explain fully the logic.
You'd be quick enough to mention that 'x' is in the wrong place if someone should attempt to do this for you, the least you can do is provide valid data in the first place.
Old computer adage: [URL="https://en.wikipedia.org/wiki/Garbage_in,_garbage_out"]GIGO[/URL]
-
Re: Processing data from one column in excel
Yeah, you are right, I did it manually so that is why I made such a misprint. Removed 14 and reloaded the attachment.
-
Re: Processing data from one column in excel
Then please explain why Item c (Phone2, Company2 in the sample) ends up as Phone2, Company1 in the results.
You should not expect anyone to make assumptions about what is correct and what is not - that just wastes time.
-
Re: Processing data from one column in excel
Ok, yes, it shifted in someway, sorry, that was late at night:(
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!