Feb 22 2021 09:17 PM
Feb 22 2021 09:52 PM
@Rustynail You could create one extra column that concatenates the six columns that may contain a project name, for instance by using:
=TEXTJOIN(,TRUE,A2:F2)
and copy it down. In this example, the six project name columns are a A to F. If they are not in adjacent columns, you can replace A2:F2 by references to each individual cell in the row, let's say B2,E2,H2,J2,M2,N2
A variant to the above you could use CONCATENATE, like this:
=CONCATENATE(A2,B2,C2,D2,E2,F2)
Feb 22 2021 09:53 PM
Feb 22 2021 09:58 PM - edited Feb 22 2021 10:00 PM
Please share some sample data along with your post ,, to justify that the project name are only in A2, B2, C2, E2 & F2 !!
May possible are in random order,, or possibly the OP wants summary for each project name since OP is looking for CONSOLIDATION!!
Feb 23 2021 09:11 PM
Feb 23 2021 11:38 PM - edited Feb 23 2021 11:40 PM
@Rajesh_Sinha Not having any concerns. Just don't understand your comment. Hence "???".
Feb 24 2021 09:36 PM - edited Feb 24 2021 09:38 PM
I have tried to raised the valid point,,, that being a solution provider one has to share the used data also,, so the readers as well OP can justify the method and believe that it works,,,, since @Rustynail has not shared any sample data so in this situation the formula shown by you is only based on assumption !!
Personally,, I do believe that DATA CONSOLIDATION is the core issue,, and the shown method doesn't addressing it !