I have 2 different worksheet.
Both are displayed by week number.
Example: There are 10 weeks number.
- Alll weeks have data.
- show 10 week number columns
- Only 9 weeks have data
- show 9 week numbers column
Then I want to put both on dashboard.
The problems is one has 10 columns, the other one has 9 columns.
I want both show 10 column.
It means need put a dummy week number on worksheet 2.
How can I do that?
If you blend your datasources on week number as common you can use week number from first and data from Second to get 10 columns