I'm trying to create a new column that combines data from multiple columns & rows if certain criteria is met. I can't seem to accomplish what I need to do using the multi-row formula, although admittedly I'm still new to that function within Alteryx.
Here is a table of example data. The header represents the column names.
| Project # | Project Name | Status | Details | Value |
| 15 | Project A | Late | Missing contractor | 1.2 |
| 15 | Project A | Delayed | Pick RFP winner | 1.2 |
| 16 | Project B | On target | N/A | .8 |
If the project number matches the project number in the row after it, I want to combine the columns & strings from Status & Details. If the project number doesn't match the project number in the row after it, I just want it to combine the columns within that row for Status & Details. Ideally the output would look like this:
| Project # | Project Name | New Field | Value |
| 15 | Project A | Late: Missing contractor
Delayed: Pick RFP winner | 1.2 |
| 16 | Project B | On target: N/A | .8 |
I'm not sure if this is not possible or just far exceeds my Alteryx knowledge. Any help would be appreciated!!
