Splitting dates in one row into multiple rows

Pepathepig

Hi, I'm trying to figure out how to split a date row in the format of YYYY.Month into two separate rows where one is YYYY and other is the month.

e.g.:

Original dataset:

Record	F1	F2	F5	F8	F11	F14
1			2022.January	2022.February	2022.March	2022.April
2			XXX	XXX	XXX	XXX
3	12345	Revenue	data	data	data	data
4	123456	Revenues non-trading	data	data	data	data
5	123457	Revenues xxx	data	data	data	data
6	123458	Revenuesxxx	data	data	data	data

Desired dataset:

Record	F1	F2	F5	F8	F11	F14
1			2022	2022	2022	2022
2			January	February	March	April
3			XXX	XXX	XXX	XXX
4	12345	Revenue	data	data	data	data
5	123456	Revenues non-trading	data	data	data	data
6	123457	Revenues xxx	data	data	data	data
7	123458	Revenues xxx	data	data	data	data

Any ideas?

Thanks a lot!

IraWatt

Hey @Pepathepig,

Here is one way to do this:

Any questions or issues please ask
HTH!
Ira

Workflow.yxmd