Macro to Sort Column Contents So That All Data Lines Up Accordingly

[Jim Clayton]

The attached workbook is laid out as follows: Blue section is unsorted data, Green and Red Sections are Columns A & B split up using Text to Column feature. Looking at the green columns, you can see that there is a lot of repetitive data, but it's scattered. I'm trying to get the similar information in one column. Example: "B7" is in about three or four different columns. I want to try getting it in one. Is there a macro that can do this? Not just for B7, but for all "like data". Would greatly appreciate the help. Tks.

[PCI]

I want to try getting it in one.

Is it to merge column A and B ???
Please give an example of the final result

[Jim Clayton]

Please see attached. Using "B8" as an example. I have highlighted the various locations that it's located in the workbook, then moved them all to Column T as a representation of how I would like to organize it, all in one column. Tks.

[Jim Clayton]

With one added request...this function is intended to be used for thousands of rows of data. So, it would need function in a manner, most likely by column. Because doing it cell by cell would be too time consuming. Thanks for your time.

[PCI]

So that means we need to make the exhaustive list of values ( B7, B8, STUD, BOLT ...) from the split columns (Green columns) then some where to prepare a column for each value in the list and point out in this columns when it exist in a row ???
It make a lot of columns no ??

[PCI]

In your example ( which is welcome) why B8T do not have its own column like B8 ?

[Jim Clayton]

Let me try another approach at this. Please see attached workbook. Is something like this possible, but on a larger scale? Tks. And regarding the B8/B8T, there's not a simple answer for it. It's an internal thing on my end. They're both considered the same. Thanks for your help.

[PCI]

The swap has to be done in the green columns ??

[Jim Clayton]

I was using the green columns as my Test area to try to do this if that's what you're asking.

[Jim Clayton]

Here we go. New workbook attached. This is what I'm after. Thanks for the help.

[PCI]

So it means we can do the swap directly into columns A, B, C ...!
With the same recommandation you mentioned: See thread #4

[PCI]

Is it what you want ???

Please Login or Register  to view this content.

[xladept]

If you select the leading column or two adjacent columns, this will switch them including the headers:

Please Login or Register  to view this content.

[Jim Clayton]

I think this might do the trick. Thank you both for your help.

[xladept]

You're welcome and thanks for the rep!

[PCI]

Good news and us informed.
Thx for the rep and enjoy Excel