The Power Query solution will be easier on days 2 through 9999 than the following steps in Excel:Įxcel gurus might suggest these steps every day: Today's article is about how to quickly solve this problem with Power Query.
Being just one tiny outpost, you don't have much chance to convince HQ that this is a horrible way to send out data. HQ is sending similar files out to 500 branch offices. To make matters worse, you are getting a new file from headquarters every day structured like this. If someone is proficient in Excel, they might want to sort the data, add subtotals, use pivot tables. Someone is then merging the remaining six blank cells with the Midwest cell to create a merged cell that is 7 cells tall.
If there are 7 rows for the Midwest region, the word Midwest appears only on the first row.
Merged cells are the problem today, but these are vertical merged cells.
0 kommentar(er)
