Actually, I believe Budapest is on the right track. I might be able to fill in some of the blanks.
Step 1 - in column B - enter the following: =A1 & "-E"
Step 2 - in column C - enter the following: =A1 & "-G"
Step 3 - in column D - enter the following: =A1 & "-T"
Step 4 - use your mouse to select B1 to D1, then press CTRL+C (to copy these three cells)
Step 5 - click on cell A1, and then CTRL+Down to go to the bottom of your data
Step 6 - click on the cell directly to the right of the last cell in your list only once to select it(possibly cell B3959)
Step 7 - press SHIFT+CTRL+Up on your keyboard (which should select all of column B with matching data in column A)
Step 8 - press CTRL+V to paste the formulas from Steps 1 to 3; this should give you four columns as follows: A = your original list, B = your original list with -E appended, C = your original list with -G appended, your original list with -T appended
Step 9 - select all of columns B through D, press CNTRL+C then right click on cell B1, and select Paste Special then Values from the resulting menus.
Step 10 - select all of the list in column B, press CNTRL+C, go to the bottom of your list in column A, and press CNTRL+V, to paste the new values under your original list.
Step 11 - Do the same with coumns C and E, copying each after the last cell in list of column A.
Step 12 - you can now delete columns B, C, and D, and sort column A to get your complete list.
If this doesn't meet your needs, you may have to go the macro way. I can help you with that, as I believe this would be a pretty simple recursive macro to put together.
Let me know how this works out for you.
Edited by adupuis, 07 September 2010 - 07:17 PM.