# How to do this using Excel code: List of values to table

#### sasori

##### New Member
Sorry for the totally undescriptive title. I'm having a hard time trying to describe it specifically using a decent title. Please treat me as a complete newbie, I have no idea what I'm doing except when using average formulas (lol).

I need to find a way on how to convert a list into a table. Given a set list of values a and b, I need to arrange them into a table.

The xlsx file is here.

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

#### FormR

##### MrExcel MVP
Hi, welcome to MrExcel!

For future questions you may want to take a look here for ways to post your example data directly in the thread - you will get many more people taking a look that way:

Here is one option though, the formula in J7 can be copied down and across.

Excel 2013
HIJKLMN
5b
612345
7a11617161315
821016161410
931317102010
1041319141713
1151319141713
Sheet1
Cell Formulas
RangeFormula
J7=INDEX(\$C\$2:\$C\$26,MATCH(1,INDEX((\$A\$2:\$A\$26=\$I7)*(\$B\$2:\$B\$26=J\$6),0),0))

Excel 2013
ABC
1abP
22510
33510
43310
52110
64513
75513
81413
93113
104113
115113
122414
134314
145314
151515
161316
172316
182216
191116
204417
215417
221217
233217
244219
255219
263420
Sheet1

Replies
3
Views
485
Replies
2
Views
533
Replies
2
Views
288
Replies
4
Views
460
Replies
2
Views
424

1,190,782
Messages
5,982,878
Members
439,803
Latest member
sushilneupane

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back