SOLVED

# Creating a table from a list of vertically sequential records

Brass Contributor

# Creating a table from a list of vertically sequential records

Hi,

If I have an excel filled with records in sequence like:

ID                     1

Property          A

ID                     2

Property          B

ID                     3

Property          C

Is there a simple way to put them in tabular format:

ID     Property

---   ----------

1            A

2            B

3            C

Thanks/Brgds

joao

best response confirmed by Joao Casqueiro (Brass Contributor)
Solution

# Re: Creating a table from a list of vertically sequential records

``=IFERROR(INDEX(\$B\$1:\$B\$10,SMALL(IF(\$A\$1:\$A\$10=E\$1,ROW(\$A\$1:\$A\$10)),ROW(\$C1))),"")``

You can use this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021. The formula is in cell E2 and filled across range E2:F8 in this example.

1 best response

Accepted Solutions
best response confirmed by Joao Casqueiro (Brass Contributor)
Solution

# Re: Creating a table from a list of vertically sequential records

``=IFERROR(INDEX(\$B\$1:\$B\$10,SMALL(IF(\$A\$1:\$A\$10=E\$1,ROW(\$A\$1:\$A\$10)),ROW(\$C1))),"")``

You can use this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021. The formula is in cell E2 and filled across range E2:F8 in this example.