Transpose Large Amount of Data

**engineerlady** · 02-07-2013, 02:04 PM

Hi,

I currently have a code (written by Mike2579 on this forum) which checks column A values, if they're similar, then it will transpose all the corresponding data in column B. It works great, and the speed is fantastic, however, I'm not having any luck with changing the code so that it transposes the values in column C, instead of B. (Also I have over 300,000 lines of data I'm working with.) Please see the attached spreadsheet for further explanation.
Any help is greatly appreciated.

Thank you.

The code is:

Please Login or Register  to view this content.

**GregJG** · 02-07-2013, 02:33 PM

I'm not expert by any means, but the part of the code where aArr= has the .offset(,1) at the end is directing it offset 1 column from "A" (which would be column B).

so if you want to compare column A to C, just as it does with A to B, you would need to change that offset to (,2).

you might have to change other part of the code, but that part is directing to column B

**GregJG** · 02-07-2013, 02:41 PM

FYI by changing the palce of the comma to (1,) would offset by row, instead of column

**arlu1201** · 02-07-2013, 02:59 PM

engineerlady,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

**jindon** · 02-07-2013, 03:03 PM

1) You need to edit your post and wrap vba code with the code tag.
It's a MUST rule here.
i.e
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

2) See if the attached is what you wanted.

**engineerlady** · 02-07-2013, 10:19 PM

arlu 1201 thanks for bringing that to my attention.

**engineerlady** · 02-07-2013, 10:23 PM

GregJG, I have done your recommendation for changing the aArr= equation. I've also changed the offset values in the code to (,2) and it still does not work. Thanks for the suggestion.

**AB33** · 02-08-2013, 04:47 AM

Mike's adjusted code

Please Login or Register  to view this content.

**jindon** · 02-09-2013, 08:58 AM

engineerlady

Sorry, but one of Admin here lost the file attached to my previous post. Not my fault.

**engineerlady** · 02-09-2013, 11:14 AM

AB33, Thank you so much for helping me with the code!! It works awesome! I appreciate you spending the time on it!

jindon, No worries on your post, I'm sorry it got lost. Thanks for your work on it. I appreciate you trying to help.

Have a great weekend!

**AB33** · 02-09-2013, 12:56 PM

Engineerlady,
You are welcome!

Transpose Large Amount of Data

LinkBack

Thread Tools

Rate This Thread

Display

Transpose Large Amount of Data

Re: Transpose Large Amount of Data

Re: Transpose Large Amount of Data

Re: Transpose Large Amount of Data

Re: Transpose Large Amount of Data

Re: Transpose Large Amount of Data

Re: Transpose Large Amount of Data

Re: Transpose Large Amount of Data

Re: Transpose Large Amount of Data

Re: Transpose Large Amount of Data

Re: Transpose Large Amount of Data

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions