Combining Rows with Matching Data while keeping unique data in some columns

Question

When I export data from a platform it creates a row for the unique data in one column.

Is it possible to combine all the rows with matching project titles to show the title, stage, category, etc once, and show all of the uniqua data in Column J in one cell to match that row?

If a formula fixes this, would I need to redo it for each project?

Answer 1

You may try macro.

====================

Sub MergeDuplicateCells()

Dim lastRow As Long 

Dim i As Long 

Application.DisplayAlerts = False 

lastRow = Cells(Rows.Count, "A").End(xlUp).Row 

For i = lastRow To 2 Step -1 

    If Cells(i, "A").Value = Cells(i - 1, "A").Value Then 

        Range(Cells(i - 1, "A"), Cells(i, "A")).Merge 

        Range(Cells(i - 1, "B"), Cells(i, "B")).Merge 

        Range(Cells(i - 1, "C"), Cells(i, "C")).Merge 

        Range(Cells(i - 1, "D"), Cells(i, "D")).Merge 

    End If 

Next i 

Application.DisplayAlerts = True 

End Sub

====================

Answer 2

From your screenshot, it could be done with filter formula or Power query.

Could you share a test file to test formula on it?

You may upload file in private message.

Answer 3

The excel sheet looks like this

Answer 4

Could you share some dummy data to test?

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

Why a sample file is important for troubleshooting. How to do it. - Microsoft Community