power query insert blank columns ....

Brass Contributor

Hi all, I am doing a pivot in power query which then gives me data in week numbers as columns for each line of product. problem is that I want to keep 12 week numbers from starting number but query only loads week numbers exists in data range. for example if there is no data in a week that week number will not appear anywhere hence query will not load a column for that week number when doing pivot. 

is there any work around to always have 12 weeks starting form the lower week number regardless of data exists for each week or not. week numbers without data can come as blank columns.

 

any help will be appreciated.

 

Thanks a lot.

2 Replies
It would help to have some sample data in an Excel workbook.

@Kashibaba , you ma generate the list with all 12 weeks appending to you main query (all other fields could be nulls) and pivot on resulting query.