Horizontal Sort

[jgilliga]

Hi,

I have a set of data that is over 2500 rows. It contains an ID column and then multiple tags associated with that ID that need to be sorted horizontally.
As comma separated it would appear as the example below.

Example:
1, ACC.d, FAS.d, 2013-2014, GRD.d
2, 2013-2014
3, MTJ.w, FAS.d, ACC.d
4, GRD.d, ACC.d

I'd like to sort these horizontally for each row and maintain the spacing if possible. Is there a function/macro I can use? I am not very familiar with Macros, so the more detailed, the better...

thanks
jg

[ChemistB]

Are you saying you want the entries in all the rows to line up? (i.e. all the "ACC.d" in col A, "FAS.d" in Col B, etc)? So given your example, in Row 3, MTJ.w might be the first entry in Col E? or are all the entries from row 2 down included in row 1?

[jgilliga]

Ideally, the ID would remain in column A, 2013-2014 would populate in column B, ACC.d would list in column C, etc... there are up to as many as 9 tags for a given ID

Thanks for your quick response.

[ChemistB]

How do I know what's the ID? Can you upload an example showing finished results (Go Advanced>Manage Attachments)

[jgilliga]

in the example I simply listed them as 1, 2, 3, 4:
Example:
1, ACC.d, FAS.d, 2013-2014, GRD.d
2, 2013-2014
3, MTJ.w, FAS.d, ACC.d
4, GRD.d, ACC.d

[TMS]

@jgilliga: simply repeating the same thing won't get any of us any closer to understanding a) what you start with and b) what you want to end up with.

As ChemistB has suggested, please upload a sample workbook with typical data before it is sorted and a mock up of what it would look like after it is sorted.

Regards, TMS

[jgilliga]

My apologies...
I didn't realize that was repetitive. The answer that was not in the first post was that you, in fact, know what the ID is as it is ALWAYS in Column A. I'm sorry if that was unclear.
Attached is a view of:

• how it is exported (in theory as the data is confidential),
• how I use 'text to columns' to separate, and
• the ideal output

thanks all!
jg

[xladept]

Hi jgilliga,

Here's a routine that I got from an esteemed forum member a while back - I pasted your:
"Tags Isolated via Data --> "Text to Columns"" in Range A1 of sheet 2 and the ran this:

Please Login or Register  to view this content.

[JBeaucaire]

Assuming the tags in question are only the 5 shown, run this macro with the data in columns A:B

Please Login or Register  to view this content.