Forum Discussion
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 u...
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
MaggieCommunity 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.
v-juanli-msft
Community Support
Community SupportHi 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
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.