Forumla for Moving/Copy Data from Single Column (Rows) to Multiple Column
I have a spreadsheet with data down column "a" only (names, addresses, etc). I want to move the data so it goes across the page under "B" "C" "D" etc.... It needs to be the actual data (text), not a formula "repeating" the data....
Example:
Column A
Row 1 Laura M. Smith
Row 2 1234 Joy Lane
Row 3 Somewhere
Row 4 CA
Row 5 99999
Need it to be:
Column A Column B Column C Column D Column E
Laura M. Smith 1234 Joy Lane Somewhere CA 99999
Thanks for any input!!
'COLUMNS TO ROWS
Here's a macro for merging columns of data to one row matching for column A.
How/Where to install the macro:
1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save as a macro-enabled workbook
The macro is installed and ready to use. Press Alt-F8 and select it from the macro list.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
THANK YOU, Forum Guru!!! I have one dilemma.... There is one blank row in the middle of a "set" of data. Know how I can edit the macro so that it recognizes the SECOND blank line in the data to mark the separation mark?
And, actually some of the second blank lines do have data in them (apartment numbers)...... :-(
You're gonna need some consistency, yes?
What are you meaning by consistency? The fifth row of each "set" is sometimes blank, sometimes with data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks