Hello, you'll have to follow certain steps to attain the desired output.
firstly you need to select the row or column that you want to generate
2. now highlight the empty row /column (hit F5 (GoTo) and select Special > Blanks)
3. now type equals, you'll get an arrow up to enter the formula with a direct cell reference to the first data label
4. now don't press enter but hold down the control button and now press enter
5. now you have to generate the formulas or the data, you'll have to select the whole column or row and copy, paste special>values.
this will help u generate the data