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.
ColinJHarrison Why not continue within PQ. The information in the dynamic array in A2:B6 can easily be created from the SourceData. And then you can add a column (in PQ) that extracts the lengths from the Name columns and merge merge with the Ages table to pick-up the ages based on the Names columns in both tables.
- And, can you apply formatting to a PQ input table (that won't get reset on update)? I've never tried that.
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!
