Cell with multiple entries in a table from URL

Question

UPDATE: Workflow attached I'm pulling in some data from the below link: https://support.fubo.tv/hc/en-us/articles/115005151127 I'm familiar with using the Text Input > Download > Text to Columns and so on to scrape the URL for the data in a table but this is the first time I have run across a cell with multiple rows like the below: The Albuquerque row comes across as: DownloadData

Albuquerque-Santa Fe, NM

-

KRQE

KOB

-

KASA

KRTN

KTEL

KLUZ

KTFQ

DESIRED RESULT: DMA NameABCCBSFOXNBCThe CWTelemundoUnivisionUniMasAlbuquerque-Santa Fe, NM--KRQEKOB-KASA,KRTN,KTELKLUZKTFQ My current workflow results split them out into their own cells which then throws the rest of the data off of their corresponding headers. TIA for any help fuboLocals.yxmc

BonusCup · Answer

These types of cells also appear in Palm Springs, CA and Waco-Temple-Bryan, TX

BonusCup · Answer

@christine_assaad

Thank you for your response. I understand how you got to the final results but I'm having an issue getting the 3 stations in the one cell under Telemundo to come out as 3 separate cells under Telemundo.

I've edited my first post to add my workflow.

Christine_Assaad · Answer

Hi @BonusCup

Is the below what you are looking for? I believe the key here is to Transpose your data points then use the Summarize tool to concatenate the Albuquerque Telemundo values.

Concatenate.yxmd