•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Best way to create a table with custom rows
Our take
Creating a table with custom rows that pulls data from various Power Query tables can feel daunting, especially with around 40 rows to manage. Fortunately, there are efficient pathways to streamline this process. Power Query and Power Pivot both offer robust solutions, enabling seamless integration of disparate data sources. By leveraging these tools, you can transform your data management experience, making it more intuitive and less time-consuming. Let’s explore the best methods to construct your table, ensuring you maximize efficiency and accuracy in your work.
I am looking to create a table where each row uses data from different power query tables.
I am going to have about 40 rows and was wondering what the best way to create this table is.
I was thinking some options are power query or power pivot but not sure what the most efficient way to complete this is.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Showing a row where no value existsI have a list of 5 countries we sell products to. And we split it into 3 product categories: internet, consulting services, phone. I have used power query to and loaded the connection into the data model, but not as a table within a worksheet. These are my total sales amount pivot tables: Filter: USA phone | 500 mill Consulting | 20 mill Internet | 30 mill Filter: New Zealand Phone | 5 mill Internet | 20 mill Problem: I need New Zealand to show Consulting and a sales amount of 0. There is no “consulting” row in the source data itself for New Zealand so “show zero values” in pivot table settings doesn’t work I figure I’ll need to create my own tables listing: Phone, Consulting and Internet as row headings. But how should I get my sales sums? I’m guessing doing xlookups using my pivot table is the data source is not best practice Do I scrap my pivot tables and load the power query as a table for sumif? submitted by /u/Interesting-System [link] [comments]
- How do I Maximize File EfficiencyI work with data sets that I typically look at forecast by year. Currently when I look at 2026 and 2027 it is rougly 1.4M lines of data. I have to put these in two separate data pulls and tables. Then I have six different customers included in this data. so I have to create 6 tabs with six diffrent pivot tables for them to look at. This has created a massive file that lags just to open, save or close so I really have two questions and am open to suggestions. Would it be better to store the data in one worksheet and then link a second worksheet that just has the pivot tables and separated look? If so how would I creat that link? Can you explain to me like I am 5 how I would use power query to combine the 26 and 27 table so that they could be in the same pivot table? Every column in both are identical. submitted by /u/dcal69 [link] [comments]
- How to create a power query to add AND consolidate informationI'm trying to create a power query which will give me the following: https://preview.redd.it/ntarieckzvqg1.png?width=904&format=png&auto=webp&s=379b5e258a7b6779d8ec2982d4e5013bfc442520 From a spreadsheet like this: https://preview.redd.it/hvu3vqz11wqg1.png?width=286&format=png&auto=webp&s=a0d2d15dbafd615c19dff6cce91ccec29a3a784f https://preview.redd.it/98r3xk741wqg1.png?width=598&format=png&auto=webp&s=a6c210c2f77dcb36d98f82b6213e62ad08193faf I'm not sure how to accomplish this. I've created the connections by getting data from folder, but I don't know how to get the data to show up like the first table in my post. Unfortunately, I'm not able to edit anything in Excel File 1 Sheet 2 Table 1, or Excel File 1 Sheet 2 Table 2 to facilitate this. submitted by /u/FurryACiD [link] [comments]
- Power query and manual table next to itHi, I want to pull data verbatim from a spreadsheet my team uses and use data from it for my own purposes. The main goal for using power query is that the data updates on my spreadsheet. Mainly, if any new entries are added at the bottom. I also have some manual fields that I need to add that correspond with the power query data. I've added another table beside the power query data, and filtering it causes the data on both sides to adjust correctly. I'm mainly concerned that, if the entries are rearranged or sorted on the original sheet, that my tables will not align after a refresh. Also, if a refresh would break my table alignments at any point. Is my fear founded? Is there a way to combine the two features that I need into a single table? submitted by /u/Perspective-Guilty [link] [comments]