Welcome Readers !
So here is a simple solution to question which many people ask me during my sessions.
Imagine when you get data in form of a pivot Report . As a simple step , you just have to copy and paste this data from pivot in a new sheet and start working on it. But can you use filters ?? Can you use formulas through out ?? The answer is NO .. But why ?? Because the first column that contains some category names ,have it written only on the top row, for others it is blank .. Right ????
So does your data looks something like this ?
Can you notice the Dept Column ? Where Department names are written just once in the top row of its particular group.
So the solution is something very simple
Here you go ...
The only thing you need to do is , Go in the very next cell of the first category name in this column. Here type the formula beginning with equal symbol (=) and select the cell above.
For example in above image, if 'Dept' is written in column 'A' and 'Admin' is written in cell 'A2' , then go in cell A3 and type the formula as =A2 and press enter.
Now copy this cell (In this example cell A3)
Next step in select this entire column and press F5 on your keyboard . This will take you to Go To dialogue Box. Now hit the 'special' button given at the bottom of this dialogue box and select the option as 'Blanks' and click 'OK'.
Can you notice all blank cells in this column are selected. And now nothing , just press Ctrl+ V to paste.
Result : Each row in data has category name written in front of it.
Hope this helps ....
So here is a simple solution to question which many people ask me during my sessions.
Imagine when you get data in form of a pivot Report . As a simple step , you just have to copy and paste this data from pivot in a new sheet and start working on it. But can you use filters ?? Can you use formulas through out ?? The answer is NO .. But why ?? Because the first column that contains some category names ,have it written only on the top row, for others it is blank .. Right ????
So does your data looks something like this ?
So the solution is something very simple
Here you go ...
The only thing you need to do is , Go in the very next cell of the first category name in this column. Here type the formula beginning with equal symbol (=) and select the cell above.
For example in above image, if 'Dept' is written in column 'A' and 'Admin' is written in cell 'A2' , then go in cell A3 and type the formula as =A2 and press enter.
Now copy this cell (In this example cell A3)
Next step in select this entire column and press F5 on your keyboard . This will take you to Go To dialogue Box. Now hit the 'special' button given at the bottom of this dialogue box and select the option as 'Blanks' and click 'OK'.
Can you notice all blank cells in this column are selected. And now nothing , just press Ctrl+ V to paste.
Result : Each row in data has category name written in front of it.
Hope this helps ....
