concatenate rows

[v-juanli-msft]

Hi @Anonymous

I don't understand how you transform the table structure.

This is your previous table

use circled part with red to get the following red part, the same as blue part

Does the first date come first row and end date come from second row of the first picture?

Why does the black part in the middle of the table occur?

why the chargebackaount is 10799.56, payment amount is 4357.1?  it is not associated to the previous table.

Best Regards

Maggie

[AlB]

Hi @Anonymous

Can you please show the exact result that you expect in the example you are describing? Post what the resulting table would look like.

It's is also better if you post the data in text format (just copy the table on the post) instead/on top of the screen capture. That allows people that want to help to readily copy the data and run some tests should they need to.