Combining 2 rows records into one

[wonka1234]

Hi,

I have a list of rows

Canada	CS	null	FAIL: Start
Canada	CS	UPDATE: Period	null
Canada	TDS	null	FAIL: Start
Canada	TDS	UPDATE: Period	null

I want to make it

Canada	CS	UPDATE: Period	FAIL: Start
Canada	TDS	UPDATE: Period	FAIL: Start

How can I remove the nulls and combine the records?

[Felipe_Ribeir0]

Hi @wonka1234 

You can use the summarize tool to do that

[wonka1234]

@Felipe_Ribeir0 

hi felipe, thanks!  But how come duplicate records are now gone into one? I want to keep duplicates ie.

Canada	CS	null	FAIL: Start
Canada	CS	UPDATE: Period	null
Canada	TDS	null	FAIL: Start
Canada	TDS	UPDATE: Period	null
Canada	CS	null	FAIL: Start_two
Canada	CS	UPDATE: Period_two	null
should now be
Canada	CS	UPDATE: Period	FAIL: Start
Canada	CS	UPDATE: Period_two	FAIL: Start_two
Canada	TDS	UPDATE: Period	FAIL: Start

[Felipe_Ribeir0 · Accepted solution]

Hi @wonka1234 

If you always have groups of 2 rows, you can use the multi row formula to create these groups and achieve the desired result:

[wonka1234]

@Felipe_Ribeir0 

using your multi formula tool  - shouldn't these be apart of the same group?

[Felipe_Ribeir0]

@wonka1234 

My multi row formula was creating groups of 2 rows each

Can you provide an sample dataset that covers all examples that you have in your data? And the expected output