I have a need to build workbooks that will pull from a list of up to 96 items and fill that into an 8x12 table on the next tab. I have a way to copy and paste the values, but this takes forever and I build these workbooks frequently. I know there has to be a way to fill the table from top to bottom, left to right. I have played in Power Query, but I can't find a way to change the column dimensions. I have attached a sample workbook with 24 items and the table on the next tab. Thanks in advance.
Bookmarks