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

Hey @Pepathepig,

Here is one way to do this:

Any questions or issues please ask :)
HTH!
Ira

[digitalmemo]

This is useful if the fields are pre-determined like in ur example. Otherwise, you'll need to add more sets of text-to-column and join tools.

[Pepathepig]

Works like a charm, thanks a lot!

[IraWatt]

No worries @Pepathepig glad it worked 😄

[binuacs]

@Pepathepig Another way of doing this with the tile tool