Forum Discussion
Concatenating according to row colours
Hello JKPieterse I am afraid there are issues in the names of the institutions. For instance, the first one is "FUNDAÇÃO HOSPITAL ADRIANO JORGE UNIVERSIDADE DO ESTADO DO
AMAZONAS" and in the file you sent bellow it is "FUNDAÇÃO HOSPITAL ADRIANO JORGE UNIVERSIDADE DO ESTADO DO AMAZONAS ONCOLOGIA DO ESTADO DO AMAZONAS".I think I managed to get around with a VBA code that identifies the colours of each row and some subsequent formulas. Please find attached.
PaulaSpinola This is very easy using Data, From Table.
Hello JKPieterse I am afraid there are issues in the names of the institutions. For instance, the first one is "FUNDAÇÃO HOSPITAL ADRIANO JORGE UNIVERSIDADE DO ESTADO DO
AMAZONAS" and in the file you sent bellow it is "FUNDAÇÃO HOSPITAL ADRIANO JORGE UNIVERSIDADE DO ESTADO DO AMAZONAS ONCOLOGIA DO ESTADO DO AMAZONAS".I think I managed to get around with a VBA code that identifies the colours of each row and some subsequent formulas. Please find attached.
Perhaps this one does work? (I didn't take the trouble of renaming the column names)
JKPieterse it still does not solve the issue. For instance, in cell F6 it says "FUNDAÇÃO CENTRO DE CONTROLE DE" whereas it should say "FUNDAÇÃO CENTRO DE CONTROLE DE ONCOLOGIA DO ESTADO DO AMAZONAS" which was split in 2 rows in the original spreadsheet.
The issue is more complicated than it seems 😕
But don't worry, I already managed to get around (see spreadsheet sent in my last post)!