Insert output in only one cell

Support
#1

Hi everyone,

what I try to achieve is pulling the anchor texts of a domain into just one cell. The anchors can be divided by a comma "," or something else.

This would help me identfiying bad websites more quickly than accessing the Majestic / Ahrefs Interface all over again.

PLUS I could create another sheet with "blacklisted" anchors which would greatly increase my efficiency.

Thankful for your answers :smile:

#2

Hi Max,

Yes, you can do it like this by combining Xpath, Dump and StringJoin:

image.png1470×470 83.8 KB

The "TRUE" argument means StringJoin should ignore empty entries.

#3

Yup, StringJoin was the function I was looking for.

I should have figured this out by myself. Thank you for the help!! Awesome support :smile: