Multi-Row Formula

[Nelso01c]

Is there a way to remove duplicates or return null within the same column using Multi-Row Formula.

In my attachments the MaterialMaster Col [B] & Right Assembly Col [C] repeats for the MateriaNumbers within the Right Assembly.

ORIGINAL

count	MaterialMaster	Right_Assembly	Item Number	MaterialNumber
1	PSK1234567	PRESSURE MEASURING STATION	0003	PSK0246810
2	PSK1234567	PRESSURE MEASURING STATION	0009	PSK0246811
3	PSK1234568	ACCESS PANEL	0002	PSK0246812
4	PSK1234569	ISO-PHASE PLATE/TAB SUBASSY	0004	PSK0246813
5	PSK1234569	ISO-PHASE PLATE/TAB SUBASSY	0006	PSK0246814
6	PSK1234569	ISO-PHASE PLATE/TAB SUBASSY	0010	PSK0246815
7	PSK1234569	ISO-PHASE PLATE/TAB SUBASSY	0011	PSK0246816

DESIRED OUTPUT

count	MaterialMaster	Right_Assembly	Item Number	MaterialNumber
1	PSK1234567	PRESSURE MEASURING STATION	0003	PSK0246810
2			0009	PSK0246811
3	PSK1234568	ACCESS PANEL	0002	PSK0246812
4	PSK1234569	ISO-PHASE PLATE/TAB SUBASSY	0004	PSK0246813
5			0006	PSK0246814
6			0010	PSK0246815
7			0011	PSK0246816

[Luke_C · Accepted solution]

Hi @Nelso01c 

Here's how I'd approach it. Multi-row can be tricky so leveraged a tile tool to group the records by the materialmaster and just keep the first record

[Qiu]

@Nelso01c 
I have replied another similar question with more columns to process.
Maybe you can take a look.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/replacing-the-repeating-value-...

@Luke_C 
Nice use with the Tile tool, I have not use it in this way. Thanks for the lighting.

[Nelso01c]

@Luke_C Thanks, This WORKED GREAT!