Text to rows, split the content into different rows

[kv-defy]

MonthYear

May 2021

June 2021

July 2021

May 2022

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

MonthYear	May 2021	June 2021	July 2021	May 2022	June 2022
Year	2021	2021	2021	2022	2022
Month	May	June	July	May	June

[PhilipMannering · Accepted solution]

This should help get you started,

[grazitti_sapna · Accepted solution]

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

[Kurohits · Accepted solution]

Hi @kv-defy 

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

[AmalinaH · Accepted solution]

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

MonthYear

May 2021

June 2021

July 2021

May 2022

June 2022

[Qiu · Accepted solution]

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