I have been using a messy query report for over 6 months and am finally convinced this was never my best approach. So this post is to ask the community for feedback.
I manage a small company that supports people with developmental disabilities. I pull medical information daily on hundreds of individuals for my managers to review. The attached is a small sample of a report but there are actually 60 categories (columns) , which always remain the same. Report pulls data from an external source via power query. Horizontal Report can be difficult to read since its runs so many columns across. So I transpose it to a Vertical layout in power query. Of course this has caused lots of issues upon refresh with formatting, which does not always carry over to new columns.
Questions:
1. Is transposing data in power query the best approach to get my data to lay out vertically?
2. Would pivot table produce similar/better results?
3. Is there a way to carry over formatting rules to new adjacent columns after refresh.
Of course all solutions must be dynamic since hundreds of entries change often. Thanks so much for all responses!
Bookmarks