I have a long Google Sheet column of cells with content looking like this:
#text: Jacob Zuma
@domain: https://www.theguardian.com/world/zuma
#text: World news
@domain: https://www.theguardian.com/world/world
#text: ANC (African National Congress)
@domain: https://www.theguardian.com/world/anc-african-national-congress
#text: South Africa
@domain: https://www.theguardian.com/world/southafrica
#text: Africa
@domain: https://www.theguardian.com/world/africa
I need it to look like this:
Jacob Zuma, World news, ANC (African National Congress), South Africa, Africa
Basically, i'm trying to find a way to get rid of all the headers (#text+@domain) and the URLs, and have only the subjects themselves, all lined-up, separated with commas.
Would appreciate help in figuring out how to do it.