Macro to copy from 1 sheet to another. (Rows to Columns)
I have an Excel spreadsheet that has names and addresses in rows. Row 1 Column 1 = Name 1, Row2 Column 1 = Address, Row 3 Column 1 = City, Row 4, column 1 = Phone.
There are thousands of these groups of 4 rows stacked.
I need to copy them so that each set of 4 things are in say, Row 1 Column 1 = Name, Row 1 Column 2 = Address, Row 1 Column 3 = City, Row 1 Column 4 = Phone.
Then I need it to move down to Row 2 and populate 4 columns in that row etc, etc, etc.
Anyone know of a macro for this?
TIA
There are thousands of these groups of 4 rows stacked.
I need to copy them so that each set of 4 things are in say, Row 1 Column 1 = Name, Row 1 Column 2 = Address, Row 1 Column 3 = City, Row 1 Column 4 = Phone.
Then I need it to move down to Row 2 and populate 4 columns in that row etc, etc, etc.
Anyone know of a macro for this?
TIA
Last Comment
Patrick Matthews
A sample file would be helpful :)
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
VERY EXCELLENT!
Many Thanks!
Many Thanks!
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
