Forum Discussion

Copper Contributor

Feb 23, 2021

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...

BI & Data Analysis

excel

Formulas and Functions

office 365

power bi

Rajesh_Sinha

Iron Contributor

Feb 23, 2021

Riny_van_Eekelen

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!!

Riny_van_Eekelen

Platinum Contributor

Feb 23, 2021

Rajesh_Sinha ???

Rajesh_Sinha
Iron Contributor
Feb 24, 2021
Please be specific & loud while responding the post ,,,, just putting ??? mark not enough to understand your concern !!
- Riny_van_Eekelen
  Platinum Contributor
  Feb 24, 2021
  Rajesh_Sinha Not having any concerns. Just don't understand your comment. Hence "???".
  - Rajesh_Sinha
    Iron Contributor
    Feb 25, 2021
    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 !