[Tanjamuse]

It's 500+ stories that I need to do it with, which is why I had hoped for another solution than doing it manually. I ilovejedd's solution:

Search field:
#your_source_metadata_column

Search for:
Category: ([^\n]+)

Replace with:
\1

Destination field:
#fandom

But the result was not what I had expected:

Spoiler:

<div><div><font face="Segoe UI, 023</font></div><div><font face="Segoe UI, F/M</font></div><div><font face="Segoe UI, sans-serif" size="2"> &lt;/blockquote&gt;</font></div></div>, sans-serif" size="2"> &lt;p&gt;&lt;b&gt;Spoilery:&lt;/b&gt; Do 1x13 &lt;i&gt;Le Morte d'Arthur&lt;/i&gt;.&lt;/p&gt;</font></div><div><font face="Segoe UI, sans-serif" size="2"><br></font></div><div><font face="Segoe UI, sans-serif" size="2">Author URL: https://archiveofourown.org/users/idrilka/pseuds/idrilka</font></div><div><font face="Segoe UI, sans-serif" size="2">by idrilka</font></div><div><font face="Segoe UI, sans-serif" size="2">Chapters: 1</font></div><div><font face="Segoe UI, sans-serif" size="2">Genre: AU, sans-serif" size="2">Language: Polski</font></div><div><font face="Segoe UI, sans-serif" size="2">Le Fay</font></div><div><font face="Segoe UI, sans-serif" size="2">Merlin (BBC)</font></div><div><font face="Segoe UI, sans-serif" size="2">Packaged: 2017-10-09 11:59:51</font></div><div><font face="Segoe UI, sans-serif" size="2">Published: 2010-05-16</font></div><div><font face="Segoe UI, sans-serif" size="2">Publisher: archiveofourown.org</font></div><div><font face="Segoe UI, sans-serif" size="2">Rating: General Audiences</font></div><div><font face="Segoe UI, sans-serif" size="2">Series: Morgan le Fay [1]</font></div><div><font face="Segoe UI, sans-serif" size="2">Status: Completed</font></div><div><font face="Segoe UI, sans-serif" size="2">Story URL: https://archiveofourown.org/works/87083</font></div><div><font face="Segoe UI, sans-serif" size="2">Summary: &lt;blockquote class="userstuff"&gt;</font></div><div><font face="Segoe UI, sans-serif" size="2">Updated: 2010-05-16</font></div><div><font face="Segoe UI, sans-serif" size="2">Warnings: No Archive Warnings Apply</font></div><div><font face="Segoe UI, sans-serif" size="2">Words: 2