Skip to main content

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.

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.

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.


@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.

Reply


Terms & Conditions