CONCATENATE data to Sheet 2 Column

[aarbuckle]

Hi,

I have a workbook with multiple rows of data which contain multiple account numbers in each column.

Example; Sheet 1

Acct. #
A1 - 32456, 34763, 27365
A2 - 77456, 77893, 67345
etc. down.

I would like to create a Macro to CONCATENATE data in to Sheet 2 in the folowing;

Acct. #
A1 - 32456
A2 - 34763
A3 - 27365
A4 - 77456
A5 - 77893
A6 - 67345

etc. down.

Is this possible?

[JBeaucaire]

CONCATENATION is the process of taking separate data and putting it TOGETHER into once string, sometimes separated by a delimiter of some kind...like a comma. So you want to DE-concatenate.

You're example is greatly simplified. Are you sure you don't want to post up a simple workbook with some actual examples of the data including what you really want to see in BEFORE/AFTER columns. The account numbers are really to be tossed and renumbered from the beginning? You sure? Since we're going to write a macro, you could opt for a more specific format in the account numbers if you wish. Best to decide that now as we do it the first time.

So mockup a sample workbook showing the real data and your desired results (before/after), point out where the results came from if not obvious in your sample data.

Then click GO ADVANCED and use the paperclip icon to post up your workbook.

[aarbuckle]

Thanks for the follow up.

Attached is a sample worksheet. Comments inserted on both tabs to show original data and were it needs to be moved.

[pike]

Hi aarbuckle

try...

Please Login or Register  to view this content.

[pike]

Hi aarbuckle

You can reply in the post no need to message me.

Please try the attachment

[aarbuckle]

Hello Pike,

Per your attachment, once I click the button it completly shades columns A - D. I can not uncover them to see if the Macro works. Not sure what is happening. Could you please take a look at it a nd let me know what I am doing wrong?

[pike]

Hi aarbuckle
I'm not to sure what you mean ?
can you attachthe problem??