Is it possible to move certain cells?

[TyColt]

Sup excel fam,


Ya'll have been amazing in the past, and now i'm facing something daunting.

Is there any way to make a cell with a value move over one column to the left and up one row without touching anything else on the sheet. I'm hoping there's someone up to the challenge here because this sheet has something like 17000 rows.....

In this sheet, row B has a UPC code, and underneath it, an item description. I need the item description moved to the left of the UPC code.... The actual sheet has 17,000 something rows. Not all of which have data. I'm linking the sheet from my google drive, as it's too big to post here.

https://drive.google.com/drive/folde..._A?usp=sharing


spread.PNG

[TyColt]

Here's the sheet with some manual work done: https://drive.google.com/drive/folde..._A?usp=sharing

[oeldere]

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[wk9128]

Try

Use mouse left click to Select column B \ keyboard CTRL + G \ location conditions \ empty value \ Confirm OK
Then Mouse right click \ select delete \ select the Row entire line

[alansidman]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[TyColt]

this sounds interesting. I hit CtRL + G after selecting row B but I'm not sure what to do from there based on your instructions.

[Fluff13]

How about

Please Login or Register  to view this content.