combining two rows, please see details, thanks

[ryanzhang487]

hi community, I would like to combine these two rows:

Original:

Date	Info 1	Info 2	Info 3	Amount 1	Amount2
00000000	A	B	C	2000	NULL
20200101	A	B	C	NULL	1000

output:

Date	Info 1	Info 2	Info 3	Amount 1	Amount2
20200101	A	B	C	2000	1000

all "info" are same for these two rows except the date we need to exclude the 00000000 and use the actual date,

I hope it makes sense,

Thank you so much in advance

[Felipe_Ribeir0 · Accepted solution]

Hi @ryanzhang487 

You can do it with the summarize tool: