Forum Discussion
Getting a table to dynamically match a variable range's row count
"Can I make a PQ combine data from multiple sources?"
Short answer, Yes! You can merge information from multiple sources. A merge works like Excel's lookup functions, but without their limitations. Just make sure that tables to be merged have at least one column in common.
"And, can you apply formatting to a PQ input table (that won't get reset on update)?"
Yes! When you have loaded a table from PQ into an Excel sheet, you most likely get a green banded table. You can change the style, column formats and table options like auto-resizing columns or not.
Right... Hadn't thought of that. Currently I PQ the source data into a hidden sheet, and then use shenanigans like this to generate a range of info sheets that the users want. But I could just compose the user sheets directly with PQ. Hmm... Some of the sheets I need to generate combine info from different PQ imports (so, my FILTER() function might be acting on one source, but my table formulas on a different source...) Can I make a PQ combine data from multiple sources?
"Can I make a PQ combine data from multiple sources?"
Short answer, Yes! You can merge information from multiple sources. A merge works like Excel's lookup functions, but without their limitations. Just make sure that tables to be merged have at least one column in common.
"And, can you apply formatting to a PQ input table (that won't get reset on update)?"
Yes! When you have loaded a table from PQ into an Excel sheet, you most likely get a green banded table. You can change the style, column formats and table options like auto-resizing columns or not.
- 😊 New things to learn! Thank you yet again Riny!
ColinJHarrison Glad I could help!