LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Sorting Individual Rows Horizontally

I have a list of instruments that I'm trying to sort in alphabetical order
from left to right. The list is part of a larger database, where each row
pertains to a specific song. I'm trying to get my list of instruments to be
in alphabetical order on each line individually. I have about 40 columns of
different instruments, and 50,000 rows, each record is unique, but some
contain similar data. So what I have right now might look something like
this:

Acoustic Guitar Strings Electric Guitar Bass Percussion

and I want it to look like this:

Acoustic Guitar Bass Electric Guitar Percussion Strings

I'm just trying to find a formula, or VB script that I can run to do this
automatically. I'm not very experienced with VB, so I'm not even sure if
this is possible, but I've exhausted google, and have come up with nothing
that works. Any help is very very much appreciated!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Splitting rows into individual columns Miasha Excel Discussion (Misc queries) 2 September 10th 07 02:56 PM
Individual record spans multiple rows Dana Excel Worksheet Functions 8 May 24th 07 06:04 PM
Exporting individual rows to Word Murf Excel Worksheet Functions 1 May 23rd 07 10:31 AM
How to turn rows horizontally to form columns? Wilhelm Excel Worksheet Functions 3 July 4th 06 12:20 PM
How do I Time stamp individual rows in excel? lost and confused Excel Discussion (Misc queries) 3 September 12th 05 01:59 AM


All times are GMT +1. The time now is 04:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"