'SSRS dynamic column issue

I am making a report in SSRS and I need to show two dynamic columns

  1. YYYY week 1, YYYY week 2..YYYY week X
  2. week 1 week 2 ...week X

The problem is that in SSRS when executing the report they are shown as follows

example:

YYYY week 1 YYYY week 2 week 1 week 2

but I need them to show

YYYY week 1 week 1 YYYY week 2 week 2


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source