Hi guys
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
Best regards
Pedro
P.S. I have excel 365
Bookmarks