What's the best way to do this?

[avastani]

without too much if statement coding in one table. I can do it in 2 tables with ease, 1 table with a lot of if statements but looking for a better way

Metric CMTD PY-MTD YTD PY-YTD

Metric1 2 3 20 18

Metric2 ....

Metric3

.....

MetricN