I wish to have a chart where column headers are broken into three lines and row ones into two
|eval sepa= Department.".".Name.".".Code
|chart values(Number) over sepa2 by sepa
The table currently looks like this:
spacer x.hr.b3 | y.it.h8
1.name1 2 | 3
2.name2 5 | 1
I'd like this:
x | y
hr | it
b3 | h8
1 | 2 | 3
2 | 5 | 1
The split will work to sort out the row headers (sepa2)
Is there a way to do similar to the column headers that won't create multiple columns?
e.g. makemv / expandmv creates the following.
x |hr | b3 | y | it | h8
\r\n does not appear to work
Many thanks for your time.