# Need to fill 8x12 table from a list of 96

1. ## Need to fill 8x12 table from a list of 96

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.

2. ## Re: Need to fill 8x12 table from a list of 96

As you have MS365, this should provide everything you need, I think: https://support.microsoft.com/en-us/...4-2eb78519ca90

3. ## Re: Need to fill 8x12 table from a list of 96

In Plate, B3:

=INDEX(SAMPLES!\$A\$2:\$A\$97,SEQUENCE(8,12))&""

4. ## Re: Need to fill 8x12 table from a list of 96

You could use a formula like this in B3 and copy it down and across.

=INDEX(SAMPLES!\$A\$2:\$A\$97,ROW()-2+(COLUMN()-2)*8)

5. ## Re: Need to fill 8x12 table from a list of 96

This worked, but filled left to right, then top to bottom. I have to go top to bottom, then left to right. But I appreciate it very much!

6. ## Re: Need to fill 8x12 table from a list of 96

This worked! Thank you!

7. ## Re: Need to fill 8x12 table from a list of 96

This achieves the goal, but I need to fill top to bottom, then left to right. Thank you for pointing me to that function though. It will be useful in the future.

8. ## Re: Need to fill 8x12 table from a list of 96

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who helped.

9. ## Re: Need to fill 8x12 table from a list of 96

The formula I posted goes from top to bottom, left to right.

You could adapt Glenn's to do the same by adding TRANSPOSE and switching row/columns.

=INDEX(SAMPLES!\$A\$2:\$A\$97,TRANSPOSE(SEQUENCE(12,8)))

10. ## Re: Need to fill 8x12 table from a list of 96

That is it right there! Perfect! You guys are the best!

11. ## Re: Need to fill 8x12 table from a list of 96

You're welcome and thanks for the feedback.

12. ## Re: Need to fill 8x12 table from a list of 96

Got it working as it should!

13. ## Re: Need to fill 8x12 table from a list of 96

You can use COUNTIF:

=COUNTIF(range,"<>0")

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1