Forum Discussion
Kashibaba
Jan 14, 2020Brass Contributor
power query insert blank columns ....
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 o...
SergeiBaklan
Jan 14, 2020Diamond Contributor
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.