Automate Column/Row/Cell Copy Pasting

[TomReprise]

Hi guys,

Simply put I have a situation which requires me to take data arranged like this (each character represents its own cell):

123ABC
454DE

And arrange it like this:
123A
123B
123C
456D
456E

There's a lot of data here, anybody able to advise how I can automate this process?

Thanks!

[Olly]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[TomReprise]

sample attached

[TomReprise]

anybody able to assist? is a macro the way to go here?

[Olly]

Try:

Please Login or Register  to view this content.

[TomReprise]

Amazing. Thank you so much... saved me about a days labour

[TomReprise]

=IF(question_answered=TRUE,mark_thread="solved")

[ccwbobby]

Try:

Please Login or Register  to view this content.

Hi Olly,

I've got a similar situation and was hoping you could help. I have attached a sample.

Thanks!

[Olly]

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.