Creating a table from a list of vertically sequential records

Question

Hi,&nbsp;If I have an excel filled with records in sequence like:&nbsp;ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Property&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2Property&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3Property&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C&nbsp;Is there a simple way to put them in tabular format:&nbsp;ID&nbsp; &nbsp; &nbsp;Property---&nbsp; &nbsp;----------1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; A2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C&nbsp;Thanks/Brgdsjoao

oliverscheurich · Accepted Answer

jcasqueiro&nbsp;=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.&nbsp;

Forum Discussion

Creating a table from a list of vertically sequential records

Share

Resources