Results 1 to 3 of 3

Thread: Format change from ‘horizontal’ to ‘vertical’

  1. #1

    Smile Format change from ‘horizontal’ to ‘vertical’

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    …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:

    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.

  2. #2
    Excel 2010 with free Power Query Add-In.
    Compatible with Office 2013 Pro Plus.
    With PQ's "UnPivot Columns"
    AKA "De-Normalize Data" for PivotTable apps.

  3. #3
    Thank you Hebds7.
    It looks great to me I'll experiment.
    Again many thanks and very much appreciated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts