Hi,
I have a dataset that is currently structured in the following format – “Multi-column 'horizontal' format” (out to 10 columns max):
…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:
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.
I have a dataset that is currently structured in the following format – “Multi-column 'horizontal' format” (out to 10 columns max):
John | Joan | Hank | Sue | ||
Mary | Jen | Cora | |||
Jen | Cora | Fred | Joan | Sue | Mary |
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:
John | Joan |
John | Hank |
John | Sue |
Mary | Jen |
Mary | Cora |
Jen | Cora |
Jen | Fred |
Jen | Joan |
Jen | Sue |
Jen | Mary |
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.