Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Split Column by first row in data box

 
 

The source for my table is a Box Office Mojo link, in which I want the latest title releases information. 

 

I want a column to have the movie title only, so just the first row in the boxes under "Release" I.E. from the photo below, I only need "John Fogerty: 50 Year Trip - Live at Bed Rocks". 

 

I looked into the split column option, but not sure how this could be done with delimiters.

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    As tested, we could split it into rows:

    Then add an index column from1, group by "header" column

    Add a conditional column

    Remove empty

    Finally, delete useless columns and get the result below

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    As tested, we could split it into rows:

    Then add an index column from1, group by "header" column

    Add a conditional column

    Remove empty

    Finally, delete useless columns and get the result below

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.