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.
