This Excel file will convert a table of two columns into a Column-Row table
Using functions only and auto-updated once the Main table update

In another word, analyze the table into wider form

I needed this one few days ago and you will need this one too.

The main formula that you need to use is:

=IF(ROW()-6>G$5,"",OFFSET($C$6,MATCH(G$6,$B:$B,0)-6+ROW()-7,0))

 

Leave a Reply

Your email address will not be published. Required fields are marked *