Forum Discussion

jcasqueiro's avatar
jcasqueiro
Brass Contributor
Oct 20, 2023
Solved

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  ...
excel
  • OliverScheurich's avatar
    OliverScheurich
    Oct 20, 2023

    jcasqueiro 

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

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 20, 2023

jcasqueiro 

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

 

Resources