Hi, I have a list of rows CanadaCSnullFAIL: StartCanadaCSUPDATE: PeriodnullCanadaTDSnullFAIL: Start CanadaTDSUPDATE: Periodnull I want to make it CanadaCSUPDATE: PeriodFAIL: StartCanadaTDSUPDATE: PeriodFAIL: Start How can I remove the nulls and combine the records?

Combining 2 rows records into one

Hi,

I have a list of rows

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?

Custom Tools

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

You can use the summarize tool to do that

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

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

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

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