Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

macro to auto transpose

  Asked By: Mona    Date: Oct 03    Category: MS Office    Views: 679
  

I have a more urgent need....a macro that I can use to
transpose column data into row data. Problem is that the rows in the column
vary in number and my experience with VBA/macros within excel is limited. I've
attached a before and after example since the live file has proprietary
information. I'm sure that this group of experts can help me in a snap.

Share: 

 

6 Answers Found

 
Answer #1    Answered By: Ramon Davis     Answered On: Oct 03

I am afraid nobody can see the attachment. As far as i know, this group  does
not deliver the attachments to the members(Most probably for the security
purposes). So, You should explain it in "text" way.

 
Answer #2    Answered By: Sarah Campbell     Answered On: Oct 03

> I am afraid nobody can see the attachment. As far as i know, this group
does not deliver the attachments to the members(Most probably for the
security purposes). So, You should explain it in "text" way. <

As an FYI...we DO accept attachments for those needing help, but
yes...thanks to spammers, we had to change that feature to moderator only
uploading files. So although you cannot attach files to group  emails...if
anyone needs help, they can request that a moderator upload a file  for group
review. Send it to a moderator (names on home page...which displays at the
bottom of all email posts) and request that it be uploaded to the problem
file for you.

 
Answer #3    Answered By: Gloria Cook     Answered On: Oct 03

How about as an insert to the email?

BEFORE
11/1/2005WANT IN COLUMN B; ROW 2WANT IN COLUMN C; ROW 2WANT IN COLUMN D; ROW
2WANT IN COLUMN E; ROW 2WANT IN COLUMN F; ROW 211/1/2005WANT IN COLUMN B; ROW
3WANT IN COLUMN C; ROW 3WANT IN COLUMN D; ROW 3WANT IN COLUMN E; ROW 3WANT IN
COLUMN F; ROW 311/2/2005WANT IN COLUMN B; ROW 4WANT IN COLUMN C; ROW 4WANT IN
COLUMN D; ROW 4WANT IN COLUMN E; ROW 4WANT IN COLUMN F; ROW 4WANT IN COLUMN G;
ROW 4WANT IN COLUMN H; ROW 4WANT IN COLUMN I; ROW 4WANT IN COLUMN J; ROW 4WANT
IN COLUMN K; ROW 4WANT IN COLUMN L; ROW 4WANT IN COLUMN M; ROW 4WANT IN COLUMN
N; ROW 4WANT IN COLUMN O; ROW 4
AFTER
11/1/2005WANT IN COLUMN B; ROW 2WANT IN COLUMN C; ROW 2WANT IN COLUMN D; ROW
2WANT IN COLUMN E; ROW 2WANT IN COLUMN F; ROW 211/1/2005WANT IN COLUMN B; ROW
3WANT IN COLUMN C; ROW 3WANT IN COLUMN D; ROW 3WANT IN COLUMN E; ROW 3WANT IN
COLUMN F; ROW 311/2/2005WANT IN COLUMN B; ROW 4WANT IN COLUMN C; ROW 4WANT IN
COLUMN D; ROW 4WANT IN COLUMN E; ROW 4WANT IN COLUMN F; ROW 4WANT IN COLUMN G;
ROW 4

 
Answer #4    Answered By: Kaysah Mohammad     Answered On: Oct 03

Did you get any joy recording a copy/paste special macro?

 
Answer #5    Answered By: Gus Jones     Answered On: Oct 03

Not sure if this will help  but.... There is a transpose  option in Paste
Special. What's the result of recording a macro  that does that.

That is... Start recording a macro, Select the range to transpose, hit Copy,
hit Paste *special*, select transpose and then stop recording.

Does the code microsoft has created help you at all?

As far as rows  in the column  to transpose goes... you could use End... Down
arrow in the recording so you go to the end of the populated column.

 
Answer #6    Answered By: Hisa Yoshida     Answered On: Oct 03

For security reasons... read spam, virus, backdoors... whatever... Attached
files are stripped out. Any file  you want/need people to look at should be
emailed directly to a moderator who can check it out and upload it to the
files area.

It's a precautionary measure I'm sure you can appreciate.

 
Didn't find what you were looking for? Find more on macro to auto transpose Or get search suggestion and latest updates.




Tagged: