Prepare a formula in columns A & B, that the company in level 1 comes automatically in CellB1 and the company in level 2 comes automatically in cellB2 and automatically on the opposite side under CellA3.

Formula for Excel Sheet – Finance Modeling

Prepare a formula in columns A & B, that the company in level 1 comes automatically in CellB1 and the company in level 2 comes automatically in cellB2 and automatically on the opposite side under CellA3 (the number of levels should come automatically).

Present a formula to drag down for Columns A & B.