- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 03, 2021 01:22 AM
Hello everyone!
I need to combine several records into one so that records with the same key accumulated all linked records in one field. That is, the table looking like this:
…would be transformed into this:
Any advice is much appreciated.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 03, 2021 09:33 AM
Hi,
Create new empty table, link it to this table. Return here, and copy-paste primary field into new linked field here. Your empty table will be filled with the unique U1,U2… and links. Add “Elect…” field as lookup. Trasfer it to linked.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 06, 2021 07:09 AM
@Alexey_Gusev thanks for your suggestion, but I would like to avoid creating additional table. Actually, I already have a solution of my problem thanks to @JonathanBowen.