split one cell subsections into rows

itahir04

Hi Team, How do I separate these subsection entered in single cell into separate rows:

Section	Section Number	Section Title
Book Sections	1.0 2.5.6 6.6.3	Half-title page Title page Copyright page

Desired Output:

Section	Section Number	Section Title
Book Sections	1.0	Half-title page
Book Sections	2.5.6	Title page.
Book Sections	6.6.3	Copyright page

Thanks,

Rana

Aaron_Harter

@itahir04Hi Rana, try using Text to Columns tools to split the data to new rows, and a Join tool to put the data back into your desired shape:

2020-03-03 data prep sample.yxmd