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:

BC-BX	…	CA-CV	…	DR-EM	…	EO-FJ
xxxxxx		yyyyyy		zzzzzzz		aaaaaa
xxxxxx		yyyyyy		zzzzzzz		aaaaaa
xxxxxx		yyyyyy		zzzzzzz		aaaaaa
xxxxxx		yyyyyy		zzzzzzz		aaaaaa

<colgroup><col style="width:48pt" span="7" width="64"> </colgroup><tbody>
</tbody>

Trying to get it to output like this:

xxxxxx

xxxxxx

xxxxxx

xxxxxx

yyyyyy

yyyyyy

yyyyyy

yyyyyy

zzzzzzz

zzzzzzz

zzzzzzz

zzzzzzz

aaaaaa

aaaaaa

aaaaaa

aaaaaa

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

 

[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.

<tbody>
</tbody>

 

[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.