How do I get a 2nd table columns on single row

[EaglesTony]

Hi,

  I have a table called "IssuesComponents" with 2 rows as follows (I calculate the Committed, Completed, Added, Removed based on the Item_Name value):

Item_Name   Key            Committed   Completed  Added  Removed

Committed   Data-123   Y                   N                 N          N

Completed   Data-123   N                  Y                  N          N

What I want is flatten this to a single row as follows:

Key            Committed   Completed  Added  Removed

Data-123   Y                   Y                 N          N

Not sure how to do this ?

[EaglesTony]

I don't understand your question. This data is coming from a file outside which cannot be combined, thus why Ineed to combine into 1 row.. The Committed, Completed,Added,Removed are Conditional Columns based off the value in Item_Name

[bhanu_gautam]

@EaglesTony , Can you please give us more details as on what basis data in committed and completed is "Y" in sample data shared from your end , what is the condition if any single row contains "Y" it will be "Y"?