Since Excel solves this so easily, and export to excel (csv or html) is quick and easy in Dynamics AX, I suggest you ask your client if Excel can solve it.
Yes. It is due to some manual work after opening Excel. Not a perfect solution .; -)
source
to share