I have an example.
There are two sheets in an excel, Sheet 1 and Sheet 2
Sheet 1 has
Sheet 2 has
Here in Sheet 2, Data 1.5 is the subset within Data 1
I would like to insert this Data 1.5 below Data 1 in Sheet1, without manual intervention and without a macro code, just by using formula.
Expected outcome under Sheet 1 is
There are two sheets in an excel, Sheet 1 and Sheet 2
Sheet 1 has
Data 1 | 50 |
Data 2 | 90 |
Sheet 2 has
Data 1 | Data 1.5 | 10 |
I would like to insert this Data 1.5 below Data 1 in Sheet1, without manual intervention and without a macro code, just by using formula.
Expected outcome under Sheet 1 is
Data 1 | 50 |
Data 1.5 | 10 |
Data 2 | 90 |