Forum Discussion
Consolidating data from multiple columns
Hi! I am working with a report in excel that contains several possible columns that indicate "project name". The challenge is, there are 6 columns to choose from, but in each row, only 1 column will h...
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)
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!!
- Please be specific & loud while responding the post ,,,, just putting ??? mark not enough to understand your concern !!
