Move Cell from underneath to alongside

**glaskow4** · 08-27-2017, 10:12 AM

This little simple task has me befuddled (easy to do at my age).

All I want to do is to move the contents of a cell below the current cell to be alongside.

Tried to attach worksheet but doesn't seemed to have worked.

I have:
A
B

I desire:
A B

Greg

**oeldere** · 08-27-2017, 11:30 AM

b1=INDIRECT(ADRESS(COLUMN(),1))

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

**glaskow4** · 08-28-2017, 10:59 AM

I was not as clear as I should have been and the upload of the sheet will explain.
I have an address as:
Street

Below street I have City, State, Zip

I want Street, City, State, Zip

As for the attachment upload, which I've done many times in the past,
I browse
select the file
open
but the file does not show up in the browse window so I can't, for some reason, upload the xlsx example.

**oeldere** · 08-28-2017, 11:06 AM

did you tried the actions in #2 (to upload your file)?

**glaskow4** · 08-28-2017, 12:22 PM

Yes. I get to the point where I'm asked to browse for the file.

Then I select the file, open but the file does not show up in the window to be uploaded.

I've done this many times before without any problem.

**mehmetcik** · 08-28-2017, 12:57 PM

Use a formula like this:-

Formula:

Please Login or Register  to view this content.

B1 is the first row of data that I am interested

Mod(Row(B1),4) returns a 1 every fourth row add or subtract from this to move up or down

the Offset command offsets the row by one. The column by 0.