Help with getting values from other rows in a table where id is the same

[peterlongley77]

Not sure if anyone can assist with this I am sure it is possible but my head is ready to explode in trying to find the answer.

I am trying to get the data from other rows where the id is the same

So the data in the table will be for example this

ID	TransDate	Type	Value
1234	10/01/2025	BE	£ 15,200.00
1234	13/01/2025	OR	£ 15,190.00
1234	25/01/2025	OT	£        10.00

And what I am looking to achieve is a table which shows the values like this. 

ID	TransDate	Type	Value	Type	Value	Type	Value
1234	10/01/2025	BE	£ 15,200.00	OR	£ 15,190.00	OT	£   10.00

There are multiple IDs within the table so it would go on and on but with only one row per ID.

Thanks in advance.

[nilendraFabric]

Hello @peterlongley77 

Not sure if I understand this properly, But I have tried to get teh results from the sample data 

[v-csrikanth]

Hi @peterlongley77 
As highlighted by @nilendraFabric , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

Thanks and regards, 
Cher Srikanth

[v-csrikanth]

Hi @peterlongley77 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.

Best Regards,
Community Support Team _ C Srikanth.

[peterlongley77 · Accepted solution]

Sorry I ended up doing it a different way in the end, this was more complicated than the way I found to do it. It was pivoting the data and merging data from a copy of the data.

[v-csrikanth]

Hi @peterlongley77 

I sincerely apologize for any inconvenience caused.

If you have found an alternative solution to resolve your issue, kindly share your approach in the forum. This will be helpful for others facing a similar challenge.

If the provided solution worked for you, please consider marking it as accepted.

Best Regards,
Community Support Team _ C Srikanth.