Format change from ‘horizontal’ to ‘vertical’

Wallaby

New member
Joined
Mar 19, 2015
Messages
3
Reaction score
0
Points
0
Hi,
I have a dataset that is currently structured in the following format – “Multi-column 'horizontal' format” (out to 10 columns max):

JohnJoanHankSue
MaryJenCora
JenCoraFredJoan SueMary
…this reads “John has a relationship to Joan, and to Hank, and to Sue” (in row 1, and similarly in all subsequent rows).

I need for it to be re-formatted (with the same meaning about ‘relationships’) to what we might call a “Paired-columns format” like this:

JohnJoan
JohnHank
JohnSue
MaryJen
MaryCora
JenCora
JenFred
JenJoan
JenSue
JenMary

I looked at Transpose in Paste Special but that seems quite different to what is wanted.

Is there is a neat way of achieving this re-formatting? I would be most grateful.

Thank you in anticipation.
 
Thank you Hebds7.
It looks great to me I'll experiment.
Again many thanks and very much appreciated.
Regards,
Wallaby
 
Back
Top