Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cacatenation script
I'd appreciate it if someone could help me out on this.
I have a large dataset with about 50,000 lines. There are seven fields across. I'd like to be able to do the following: The computer cacatenates all the fields in the dataset into one continuous line across for each of the rows in the dataset. Then, for each row for which the name in the first column is the same, it cacatenates that row after the previous row with the same field name in the first column, and does this for all the rows. For example: country year note1 etc... France 1990 abcd England 1991 abcd France 1994 1234 France 1993 aaaa England 1992 1234 USA 2000 bbbb becomes cacatenated as: France 1990 abcd 1994 1234 1993 aaaa etc. England 1991 abcd 1992 1234 etc. USA 2000 bbbb Thanks in advance. Matthew Kramer *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cacatenation and SUMPRODUCT | Excel Discussion (Misc queries) | |||
cacatenation code | Excel Programming | |||
Excel 2000/XP script to Excel97 script | Excel Programming | |||
VB Script Help | Excel Programming | |||
VB Script help | Excel Programming |