Creating a table from a list of vertically sequential records

[Joao Casqueiro]

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

[#2 · Accepted solution]

@Joao Casqueiro 

=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.