Posts by dazedays

I have a list. Three Columns

Like the Following:

NAME | NUMBER | TYPE

John D | 1237 | Mobile
John D | 123*5*5 | Radio
Tim ....| 1245 | Home
Tim ....| 2356 | Work

Where Name = any name
Number = telephone or other number (Includes AlphaCharacters)
Type = 10 different variables.

I want to keep the original data intact, and create a secondary worksheet with list in this manner (Merge Duplicate Names):

(Create a Header Row)

NAME | WORK | RADIO | HOME | MOBILE
John D |-------| 123*5*5|--------| 1237
Tim ... | 2356 |--------| 1245 |-------

---- = no entry (Did this to keep the space between my example.

I have a spreadsheet I want to replace the asteriks in because they don't allow my formulas to compute properly.

If I use the replace tool, the asterik indicates a wildcard or all.
so when I request the app to replace * and substitute with "|" for example the replace tool assumes I mean all not the literal * symbol.

Is there a way to tell the replace tool I want to remove the actual * from the cells, and not all?

At the end of my macro, once the formulas are completed, I will then replace | with * to resolve the formula and macro errors.

HELP!

I am working with a database that contains the following information

(This the the data array)

NAME | NUMBER | TYPE

In the name column, there are duplicate names.

In the "type" column, they're are multiple types:

"WORK,HOME,FAX,EMAIL,RADIO,OTHER"

My dilema is, I'm trying to create a formula so that the following happens.

I want to have Excel sort by "type," then transition the "numbers" from the original column "type" to new columns equal to their "type"

Example:

(Original Data)
NAME | NUMBER | TYPE
Jeff | 1234567 | HOME
John | 7654321 | WORK
John | 8765432 | HOME

(After Macro or Formula or Both) I'd also assume on "Sheet Two"

NAME | NUMBER | TYPE | HOME | WORK | FAX | OTHER | RADIO |
Jeff |............|............|1234567 |.............|...........|............|............|
John |............|............|8765432 |7654321 |...........|............|............|

As you can see the formula, and/or Macro automattically determines three things:

1. It locates the data from column 2 and places it into the proper column whereas the data in column 3 = header row of column(s) 4-8.

2. If the "type" data matches the header text, the data in column 2 moves to the the correct column.

3. If there is a duplicate name in column 1, the formula will enter the data into the proper column, but will enter the data into the topmost duplicate named row, and then when all data from column 2 is moved, it will delete the extra duplicate rows.

I'm going crazy trying to get this done so that excel can automate this time consuming process.

I get lists 600+ and I need to reorder them according to the above format, it
would be extremely helpful if one the gurus on this site could help me with some general or advanced formulas!

Thanks,