Move First 3 Items in Column A to Rows B, C, D with Macro rather than Excel Formula

[SGMacro]

I have the following macro that removes blank cells from column A.

Sub RemoveEmptyCellsFromColumn()
On Error Resume Next
Columns("A").SpecialCells(xlBlanks).EntireRow.Delete
End Sub

On the same sheet I have the following excel formula to transfer the first 3 items from column A into "B1, C1, D1" then "B2, C2, D2", etc.
This is because items in column A are in groups of 3 related items that I need to move into rows.

I have tried to build a macro to transfer that does the same as the excel formula but am new to this and don't know where to start. Can anyone help with this??

[FONT=Lucida Grande]=OFFSET([COLOR=#0057D6]$A$1[/COLOR],COLUMN[COLOR=#006107]()[/COLOR]-2+[COLOR=#006107]([/COLOR]ROW[COLOR=#AB30D6]()[/COLOR]-1[COLOR=#006107])[/COLOR]*3,0)[/FONT]

 

[hiker95]

SGMacro,

1. What version of Excel, and, Windows are you using?

2. Are you using a PC or a Mac?

To start off, and, so that we can get it right on the first try:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, PNG file, or, flat text) try one of the following:

MrExcel HTML Maker
If you do not know how to install and how to use HTML Mr.Excel Maker
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be

Excel Jeanie
Download

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


The following is a free site:

Or, you can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.

 

[SGMacro]

Hi Hiker95,

I am on a Mac using Microsoft Excel for Mac 2011, Version 14.5.3.

Here is a link to the file in Box.net

 

[hiker95]

SGMacro,

I have no experience with a Mac.

You may want to try changing/adding to the your thread title: Move First 3 Items in Column A to Rows B, C, D with Macro rather than Excel Formula, on a Mac

This will help you find someone with Mac experience.

And, click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[SGMacro]

Move First 3 Items in Column A to Rows B, C, D with Macro rather than Excel Formula, on a Mac

Bump