Don't know how to work with this but i think it is what i need, not sure.
I have a big table with all my clients and the personal attached to them, responsable to them (they're called Tec).
It is supposed to have just one person for each client but i see i have many times 3, 4 or even 5.
In query editor, after i have cleaned the database and all, also after those split columns for each person, now i have to many fields.
I have the client name, number, date, code for this, code of that, and....tec1, tec2, tec3, etc, due to my split column.
The question is simple: How can i have just one tec field among all those columns?
Let me attach my file.
Many thanks for your answers
P.S. I have excel 365
I guess the issue I and anyone will have is that you have split by delimiter creating multiple users so
If I look at Row 3 in you jpg I have to guess that before the split Tec1 consisted of 5 or more names.
If you made the actual file available and not a screenshot we would be able to follow through what you are trying to do.
if it is just that there are now duplicate records add an index column before you start then remove duplicates over the index column. But without a clearer idea of what you are doing it is very difficult to solve.
Tks for your reply.
Yes, that jpeg is an image of what i've done so far, that means, i've splited 5 or 6 times a column till it's ok.
Now the rule to unsplit i don't know cose, i've tried and it does not show what i would like.
The thing is that I have a client with, in this case, 5 tec or 6 or 4. Each one has a % of working.
I know how much is worth my client. But i would like to know what's worth the job of each tec for that cliente, and each tec with all clients.
Before i had client name, number, code, company, group, tec %, state and periode.
Now i have client name, number, code, company, group, state, periode, Tec1, %1, Tec2, %2, tec3, %3, tec4, %4....
Hope i could help