Creating a table from a list of vertically sequential records

Brass Contributor



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




1 Reply
best response confirmed by Joao Casqueiro (Brass Contributor)

@Joao Casqueiro 


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.

table from list.png