Moving cells from one column into multiple columns

Hello, all.

Currently using Excel 2010. I have all the data I need in column A, but I would like to spread it out across different columns.

To simplify what I'm doing, I would like to go from:
A1
A2
A3
A4
A5
A6
A7
A8

To:
A1 A2 A3 A4
A5 A6 A7 A8

I've been moving the cells individually and then deleting the extra rows, but I would much prefer to use a macro or some other faster method. What I would actually like to do is a bit more than just spreading out all the data, but I figured if someone could at least point me in the right direction with this starting block, I could play with it and hopefully learn to figure it out on my own.

I appreciate any help you guys can offer! Thanks!

EDIT: I know I can just transpose using Copy>Paste Special, but then I still have to go through and delete all those rows. I was hoping for something that could consolidate the process a bit and possibly be edited if I need to expand my parameters.

RetroJK,

Welcome to the Excel Forum.

With your raw data in worksheet Sheet1, beginning in cell A1 down.

The below macro will write your results to range C1:F2.

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Please Login or Register  to view this content.

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the ReorgData macro.


In the future you may want to describe in detail what you have and what you want, but, attach a sample workbook, so that we can get it right the first time.

To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data changed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

To attach your workbook, scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.

RetroJK,

It is always best to start with the actual raw data (sensitive data changed) - that way a resolution can usually be on the first try.

With you raw data in worksheet Sheet1, and the results will be in a new worksheet Results.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the ReorgDataV2 macro.

Your code worked perfectly and it's easy to read so I can make simple edits to it very easily. I should have just left it to you from the start like you told me to! So much for my MacGyver approach. haha

Thanks again!

Edit: Also, thanks and sorry to whatever mod moved my thread to the correct forum!

RetroJK,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.