Copy three column ranges to a new worksheet? Possible to do?

[heathclif]

This seems like it would be easy, but for the life of me I can't figure it out.

I have three column ranges on a worksheet and i was trying to copy them to a different worksheet.

BC-BX
CA-CV
DR-EM
EO-FJ

I think the column lengths are all equal.

Is this even possible using Excel? Or do I need to migrate the data to Access or Oracle 12c?

 

[heathclif]

I've now rated my own thread as "terrible," because of initial overconfidence.

 

[heathclif]

Maybe someone can give a hint about the output...so when the copied ranges are sent to another worksheet, how does one get them to copy on top of each other? I wish I could change the title of this post.

 

[PCL]

Can you prepare a short example to explain the data layout and show the result: In your first thread it seems there is 4 ranges is it ?

 

[heathclif]

Or is this question to general? Or neigh impossible, dare I say?

 

[heathclif]

The input data columns looks like this:

[TABLE="width: 448"]
<colgroup><col style="width:48pt" span="7" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"]BC-BX[/TD]
[TD="width: 64"]…[/TD]
[TD="width: 64"]CA-CV[/TD]
[TD="width: 64"]…[/TD]
[TD="width: 64"]DR-EM[/TD]
[TD="width: 64"]…[/TD]
[TD="width: 64"]EO-FJ[/TD]
[/TR]
[TR]
[TD]xxxxxx[/TD]
[TD][/TD]
[TD]yyyyyy[/TD]
[TD][/TD]
[TD]zzzzzzz[/TD]
[TD][/TD]
[TD]aaaaaa[/TD]
[/TR]
[TR]
[TD]xxxxxx[/TD]
[TD][/TD]
[TD]yyyyyy[/TD]
[TD][/TD]
[TD]zzzzzzz[/TD]
[TD][/TD]
[TD]aaaaaa[/TD]
[/TR]
[TR]
[TD]xxxxxx[/TD]
[TD][/TD]
[TD]yyyyyy[/TD]
[TD][/TD]
[TD]zzzzzzz[/TD]
[TD][/TD]
[TD]aaaaaa[/TD]
[/TR]
[TR]
[TD]xxxxxx[/TD]
[TD][/TD]
[TD]yyyyyy[/TD]
[TD][/TD]
[TD]zzzzzzz[/TD]
[TD][/TD]
[TD]aaaaaa[/TD]
[/TR]
</tbody>[/TABLE]

Trying to get it to output like this:

[TABLE="width: 64"]
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"]xxxxxx[/TD]
[/TR]
[TR]
[TD]xxxxxx[/TD]
[/TR]
[TR]
[TD]xxxxxx[/TD]
[/TR]
[TR]
[TD]xxxxxx[/TD]
[/TR]
[TR]
[TD]yyyyyy[/TD]
[/TR]
[TR]
[TD]yyyyyy[/TD]
[/TR]
[TR]
[TD]yyyyyy[/TD]
[/TR]
[TR]
[TD]yyyyyy[/TD]
[/TR]
[TR]
[TD]zzzzzzz[/TD]
[/TR]
[TR]
[TD]zzzzzzz[/TD]
[/TR]
[TR]
[TD]zzzzzzz[/TD]
[/TR]
[TR]
[TD]zzzzzzz[/TD]
[/TR]
[TR]
[TD]aaaaaa[/TD]
[/TR]
[TR]
[TD]aaaaaa[/TD]
[/TR]
[TR]
[TD]aaaaaa[/TD]
[/TR]
[TR]
[TD]aaaaaa[/TD]
[/TR]
</tbody>[/TABLE]

 

[PCL]

Does "BC-BX" means columns BC to BX ??
What is the first row ?

 

[heathclif]

That's right. BC to BX is the range from Columns BC to the Columns BX. Also the same for CA-CV, DR-EM, EO-FJ. So there are a total of 4 ranges.
[TABLE="class: cms_table, width: 448"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
</tbody>[/TABLE]

 

[heathclif]

Did anyone see that old movie where that crazy woman kidnaps a famous author and keeps him in bed with a typewriter? Anyone remember the name of that film? It was originally a book i think.

 

[Rick Rothstein]

Did anyone see that old movie where that crazy woman kidnaps a famous author and keeps him in bed with a typewriter? Anyone remember the name of that film? It was originally a book i think.

The name of the movie was "Misery" with James Caan and Kathy Bates.