krisso
12-16-2021, 01:44 PM
Hello,
I have a spreadsheet with two tabs: articles and images. My articles tab has 2 columns: art_id and content, while my images tab has also two columns: img_id and art_id. Each art_id in the images tab can have more rows and img_ids assigned to it (so each article can have multiple images).
I'd like to have a column on my articles tab where I would have all the img_ids belonging to the proper art_id assigned in the images tab.
This could be done probably via a Power Query, but that's beyond my skillset. Any help appreciated.
I attach my demo spreadsheet.
I have a spreadsheet with two tabs: articles and images. My articles tab has 2 columns: art_id and content, while my images tab has also two columns: img_id and art_id. Each art_id in the images tab can have more rows and img_ids assigned to it (so each article can have multiple images).
I'd like to have a column on my articles tab where I would have all the img_ids belonging to the proper art_id assigned in the images tab.
This could be done probably via a Power Query, but that's beyond my skillset. Any help appreciated.
I attach my demo spreadsheet.