2 dimension under each other

[Mizo]

I have a dimension with the following date
number:
1
2
3
4
5

and another dimension with the data
Character:
A
B
C

Now I want to create both dimensions under each other and not next to each other
It must look like this

All:
1
2
3
4
5
A
B
C

Can someone help?

[sergio0592 · Accepted solution]

You can do this if your dimensions comes from two differents tables. eg

TAB1:
LOAD *
INLINE [
Number
1
2
3
4
5
]
;

Concatenate

TAB2:
LOAD *
INLINE [
Char
A
B
C
D];

  After that, add a dimension in your chart with 

=if(IsNull(Number),Char,Number)

[Mizo]

Hello Sergio,

Thanks for your quick support
Concatenate was the right Keyword 🙂
It works 

Thanks and best regards,

Mizo

[sergio0592]

No problem, happy to help community. Dont't forget to close the topic with 'Accepted as correct solution'