Export CSV or table contins **Split metrics by ** in table does not exports correctly

[kishorkumar]

This report table is created using lens and have used the Split metrics by to show it per day in columns
my report on looks like this in lens.

but when i download as csv then its messed up

you can all the per day dates are just moved to the left one column.

kibana lens elasticsearch