Hi LJ,
Follow the below mentioned simple steps to pull up the values of Column G.
- Select the data G2 to G1048576 (mean to say: select the G column data
from G2 to till last the column, Don't select G1 to G1048576)
- Press F5
- Click on Special button
- Select Blanks
- Press O
Dear LJ,
Can you please share the little detail about your requirement ? with some
other sample ?
Thanks & Regards,
Ganesh N
On Thu, Sep 4, 2014 at 10:40 PM, LJ wrote:
> Ganesh,
>
> Thanks for the reply. When I do that the other products beneath are left
> without values in columns 4 and 6.
>
Ganesh,
Thanks for the reply. When I do that the other products beneath are left
without values in columns 4 and 6.
On Thursday, September 4, 2014 1:08:02 PM UTC-4, Ganesh N wrote:
>
> Hi LJ,
>
> Just select the data -> ctrl + G -> special -> blanks -> ok - > right
> click - > delete - > Shif
Hi LJ,
Just select the data -> ctrl + G -> special -> blanks -> ok - > right click
- > delete - > Shift cells up.
Thanks & Regards
Ganesh N
On Thu, Sep 4, 2014 at 10:27 PM, LJ wrote:
> Hi Everyone!
>
> I am working on a sheet where I have the Product listed in Column A, app
> in Column B and
Hi Everyone!
I am working on a sheet where I have the Product listed in Column A, app in
Column B and Cat 1 in Column C. These 3 columns are fine. The issue I run
into is column 4 and Column 5 have values that don't line up with column 6.
Basically, I don't want to have to drag all the values f
