Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel Macro to move columns to 1 row after each other.

02 Jul 2015   #1
brubakes

Windows 8.1 Professional 64bit
 
 
Excel Macro to move columns to 1 row after each other.

I was hoping someone could help me write or find a macro that would take two columns and move it to column A under the previous data and repeat for all columns. Basically user information is located in pairs of columns (typeofvalue, value). So column A and B are for user1, column C and D are user2, column E and F are user3, etc. Bonus if I could have a space in between each once moved.

Current:

HTML Code:
A			B			C			D		
User1First		User1Last		User2First		User2Last
User1ValueTypeA1	User1ValueB1		User2ValueTypeA1	User2ValueB1
User1ValueTypeA2	User1ValueB2		User2ValueTypeA1	User2ValueB1
Desired:

HTML Code:
A			B
User1First		User1Last
User1ValueTypeA1	User1ValueB1
User1ValueTypeA2 	User1ValueB2

SPACE/EMPTY ROW

User2First		User2Last
User2ValueTypeA1	User2ValueB1
User2ValueTypeA1	User2ValueB1
Each user has 47 rows of "values", for the example I just did two rows worth.


My System SpecsSystem Spec
.
07 Jul 2015   #2
Dude

Windows 10 Pro X64
 
 

I did a quick google and found this. It worked for you?

Excel macro to move columns to 1 row after each other
My System SpecsSystem Spec
08 Jul 2015   #3
brubakes

Windows 8.1 Professional 64bit
 
 

Quote   Quote: Originally Posted by Dude View Post
I did a quick google and found this. It worked for you?

Excel macro to move columns to 1 row after each other
Yes it did, thank you for checking in. I've marked this thread as solved.
My System SpecsSystem Spec
.

Reply

 Excel Macro to move columns to 1 row after each other.




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
how to divide row into 2 columns in excel
I need to create this table in Excel, How do I create table like I attached? How do I divide 2 row into 2 columns. Im using mac 2013 office. please help thx
Microsoft Office
Clicking on files move the columns in the folder...
Hi, I have this annoyng thing that i'm not able to change in windows 7 : when i browse a folder (i have the list visualization) if i have many files what happens when the folder is not enlarged (most of times) is that i see 2 colums of files. If i click on a file on the second column, that...
General Discussion
Web site data to excel columns
Is it possible to fetch some lines of data from a group of web pages and paste in to Excel?Pls view the image for required excel columns. urls are, Stock Share Price dlf ltd | Get Quote dlf | BSE Stock Share Price dlf ltd | Get Quote dlf | BSE Stock Share Price jaiprakash associates ltd | Get...
Browsers & Mail
Can't open 2003 Excel Files in Excel 2007?
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
Microsoft Office
uac crashes excel macro
Hi, I am having a problem when I try to run an excel macro addin (ie vba functions) that calculates some statistics, it doesn't work. Shows permission denied. When I turn off UAC, It works. Is there any fix for this? Turn UAC on and off is too annoying...cos u need to reboot each time.
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 22:12.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App