Text to rows, split the content into different rows

Question

MonthYearMay 2021June 2021July 2021May 2022June 2022

Originally I have this format, I would like to split the year and month while keeping the original MonthYear row. How do I split them accordingly? Similar concept to text to columns but now it is in rows.

Desired outcome:

MonthYearMay 2021June 2021July 2021May 2022June 2022Year20212021202120222022MonthMayJuneJulyMayJune

philipmannering · Accepted Answer

This should help get you started,

grazitti_sapna · Accepted Answer

@kv-defy, another way of solving this problem.

Kurohits · Accepted Answer

Hi @kv-defy

One of the other way of doing that. Find the attached solution workflow.

AmalinaH · Accepted Answer

This should get your ideal output. The last three tools are just for renaming and sorting to get the ideal field names and sort by year first (if necessary).

This also works off the basis that the MonthYear row is your headers row and there are data rows below. Otherwise the first solution posted is good to go

MonthYearMay 2021June 2021July 2021May 2022June 2022

Qiu · Accepted Answer

@kv-defy 
I am bit late for the party I guess.
In case you data comes as header only.

We can do something as below

I try to keep the order of the column with a RecordID and use Dynamic Rename to name it back.