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 · Accepted solution]

@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:

[itahir04]

Thank you so much, very easy solution.

Regards,

Rana