You can do this with a template like the following:
Code:
program:
result = '';
result = list_union(result, list_re($tags, ',', '(.+)', 'tags.\1'), ',');
result = list_union(result, list_re($#authortags, ',', '(.+)', 'authortags.\1'), ',');
result = list_union(result, list_re($#ratingtags, ',', '(.+)', 'ratingtags.\1'), ',');
result = list_union(result, list_re($#awardtags, ',', '(.+)', 'awardtags.\1'), ',');
Each of the "result = list_union" lines adds items from a column prefixed with whatever you put in front of ".\1". You will need to add more lines to deal with the other columns, following the pattern.
This template requires calibre 5.14 or later.
NB: You can edit the template for the tags-like column using F2 (or whatever the edit key is on your system) in the library view.