User Profile
Andrew__K
Brass Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Symbol Vertical Alignment
Can anyone tell me if the vertical alignment of a symbol can be adjusted? Wanting to use Segoe Fluent Icons as bullets, but the fluent symbols are aligned with the top of the line space and the text is aligned in the middle. Hoping I can get the symbol and text to be aligned. See below examples, 2nd example is using Segoe Emoji, which aligns fine. TIA Edit: Worth noting, the symbol appears vertically aligned when there is no text next to it.Re: Best way to segregate certain rows into each of their own worksheet from a primary
NotSoFastEddie you can use FILTER to achieve this. =FILTER(A1:G11,A1:A11="PCODE") or below using your table references =FILTER(TBL_Bouquets,TBL_Bouquets[Record Type]="PCODE") Repeat on each sheet for each record type. You could also use Power Query from Table/Range and simply filter by Record Type then load to corresponding sheet.Power Query not behaving as expected.
I use a Power Query that pulls data from files in a folder, the data is a daily report of product that has been transferred from one warehouse to another. Typically, the cartons of product are scanned to a pallet number (SSCC) and the SSCC is transferred between warehouses. I use the Sample File (First file in folder) to transform and filter out unwanted columns/rows, then the main query groups the product by the SSCC, etc... The PQ has worked fine since I created it, however, I recently came across an issue when for the first time a single carton that hadn't been scanned to an SSCC was transferred between warehouses. The SSCC number is in column 8 of below examples of source data, when the single carton without an SSCC number is included (highlighted below), it shows the cell as empty, and the product rows below it have the SSCC as usual. However, when processed by the query, it is showing every row as null in column 8. I would expect null for the empty cell, the row without an SSCC number, but I can't figure out why it is showing null for every row... Far as I can tell, the source data is no different, other than the cell missing the SSCC number. Even when I change the sample file source to the problem file, the whole column shows null at the first step. Can anyone point out something I'm missing, or what I can do to fix? Any help would be appreciated! Thank you. Example 1 - Typical source data, PQ works as expected. Example 2 - Source data with single missing SSCC number (Col-8)Re: Auto populate and expand table from range on another sheet
The master sheet isn't a table, it contains data that gets added from a CSV report each week. The table on the other sheet has helper columns such as DAY and MONTH, batch number, etc... This table is then used to populate a printable calendar.Auto populate and expand table from range on another sheet
I am trying to automatically populate and automatically expand a table with data from a range in another sheet. Each week new data is added to the master sheet from a production report, I would like the separate table to automatically fill and expand as data is added to the master sheet. I figured using a named range with an offset column reference could work, but not sure the table will auto expand? Is it possible to do this? I feel like I am missing something simple. TIARe: Need the ability for external users to upload files into MS Forms
AlexUnipa https://experience.dynamics.com/releaseplans/?app=Customer+Voice&status=new Edit: the page says preview, and if thats just a preview to a new release plan template… and they used that feature as a preview, it’s pretty cruel 😂
