cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NOWcorp Frequent Visitor
Frequent Visitor

concatenate rows

 
2 REPLIES 2
Super User
Super User

Re: Combining Multiple Columns in a Table Using a Unique ID, Then Creating New Columns....

Hi @NOWcorp

 

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.

Community Support Team
Community Support Team

Re: Combining Multiple Columns in a Table Using a Unique ID, Then Creating New Columns....

Hi @NOWcorp

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

This is your previous table

3.png

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

4.png

 

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

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,837)