Forum Discussion
Help with getting values from other rows in a table where id is the same
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.
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.
5 Replies
- nilendraFabric
Super User
Hello peterlongley77
Not sure if I understand this properly, But I have tried to get teh results from the sample data - v-csrikanth
Community Support
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
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. 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
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.
