shifting of data to fill into blank cells
thanks bj :) very helpful
thanks community
--
oldLearner57
"bj" wrote:
try in column C
=A1 & B1
copy down as far as you need to
Copy column C and paste values over column A
Delete columns B and C
"tikchye_oldLearner57" wrote:
hi community
how can i shift of move the data from one colum to another column empty cells:
example:
A B
1 Apple
2 Orange
3 Melon
4 Strawberry
the example above shows 2 columns with 4 rows and I want to move B2 & B4
to fill into A2 & A4
instead of using cut and paste and I need to do several times if my data has
more rows, is there any quicker way to shift my data to fill up the empty
cells in column A ?
thanks community for the help
--
oldLearner57
|