Sorting rows in a matrix

Hi there,

I have a matrix visual with rows"Budgeted Ebit" and columns "EAC Ebit" over weeks. As you can see in sample data the Bdgt Ebit only changes every so often, not every week, so ideally I would like to have the rows show only one row per value and plot the EAC Ebit in the same line until Bdgt Ebit changes. 

Yet, the values are automatically sorted from small to large.

I can't sort the column beforehand by date column as I have multiple identical values, so throws error.

If I add the date to rows, I get a row for each date, so lots of repeats and each week value for EAC Ebit in a separate row. Makes for a lot of scrolling.

I tried to group by Bdgt Ebit value, assigning first date it occurs, but then EAC Ebit values don't all have a matching date row, therefore plot in empty row.

Can somebody point me in the right direction please?

Thanks!!

with dataautomatically sorted ascendingSample data