how to create data type with some missing data

[Ewa_28]

hi,

Please see below table. Could you help me, please?

I have	I have	I have	I have	I want to have	I want to have
region	atrybut	year	month	I want - data type	I want also
CM	sales 1	2021		2021	2021
CM	sales 1	2022		2022	2022
CM	sales 1		January	January 2023
CM	sales 1		February	February 2023
CM	sales 1		March	March 2023
CM	sales 1		April	April 2023
CM	sales 1		May	May 2023
CM	sales 1		June	June 2023
CM	sales 1		July	July 2023
CM	sales 1		August	August 2023
CM	sales 1		September	September 2023
CM	sales 1		October	October 2023
CM	sales 1		November	November 2023
CM	sales 1		December	December 2023	2023
CM	sales 2		January	January 2024
CM	sales 2		February	February 2024
CM	sales 2		March	March 2024	Q1 2024
CM	sales 2		April	April 2024
CM	sales 2		May	May 2024
CM	sales 2		June	June 2024	Q2 2024
CM	sales 2		July	July 2024
CM	sales 2		August	August 2024
CM	sales 2		September	September 2024	Q3 2024
			next months
PN	sales 1	2021
PN	sales 1	2022
PN	sales 1		January	January 2023
PN	sales 1		February	February 2023
PN	sales 1		March	March 2023
PN	sales 1		April	April 2023
PN	sales 1		May	May 2023
PN	sales 1		June	June 2023
PN	sales 1		July	July 2023
PN	sales 1		August	August 2023
PN	sales 1		September	September 2023
PN	sales 1		October	October 2023
PN	sales 1		November	November 2023
PN	sales 2		December	December 2023	2023
PN	sales 2		January	January 2024
PN	sales 2		February	February 2024
PN	sales 2		March	March 2024	Q1 2024
PN	sales 2		April	April 2024
PN	sales 2		May	May 2024
PN	sales 2		June	June 2024	Q2 2024
PN	sales 2		July	July 2024
PN	sales 2		August	August 2024
PN	sales 2		September	September 2024	Q3 2024
			next months

thank you in advance

[Ewa_28 · Accepted solution]

Hi @PhilipTreacy 

Thank you for your answer, but I have fixed my problem by myself.

regards, Ewa

[PhilipTreacy]

Hi @Ewa_28 

The problem and what you want is not clear.

Please try stating again the problem and explain with a clear example what your desired result is.

Regards

Phil