+ Reply to Thread
Results 1 to 2 of 2

Formula for transform data horizontal.

  1. #1
    Registered User
    Join Date
    10-09-2017
    Location
    Ljubljana, Slovenia
    MS-Off Ver
    2010
    Posts
    1

    Formula for transform data horizontal.

    Example 1:

    excel1.png

    Example 2:

    excel2.png

    I want to know the formula for change Example 1 to Example 2.

    Please help me!

    Thanks a lot!

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Formula for transform data horizontal.

    Enter in C2 and copy down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Enter array formula in D2 and drag formula across and down
    ***Array formula
    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
    You will know the array is active when you see curly braces { } appear around your formula.
    If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Unknown
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    1
    Name 1 Name 2
    2
    NAME-A NAME-A-1 NAME-A NAME-A-1 NAME-A-2 NAME-A-3 NAME-A-4 NAME-A-5 NAME-A-6 NAME-A-7 NAME-A-8 NAME-A-9 NAME-A-10
    3
    NAME-A NAME-A-2 NAME-B NAME-B-1 NAME-B-2 NAME-B-3 NAME-B-4 NAME-B-5 NAME-B-6 NAME-B-7 NAME-B-8 NAME-B-9 NAME-B-10
    4
    NAME-A NAME-A-3 NAME-C NAME-C-1 NAME-C-2 NAME-C-3 NAME-C-4 NAME-C-5 NAME-C-6
    5
    NAME-A NAME-A-4
    6
    NAME-A NAME-A-5
    7
    NAME-A NAME-A-6
    8
    NAME-A NAME-A-7
    9
    NAME-A NAME-A-8
    10
    NAME-A NAME-A-9
    11
    NAME-A NAME-A-10
    12
    NAME-B NAME-B-1
    13
    NAME-B NAME-B-2
    14
    NAME-B NAME-B-3
    15
    NAME-B NAME-B-4
    16
    NAME-B NAME-B-5
    17
    NAME-B NAME-B-6
    18
    NAME-B NAME-B-7
    19
    NAME-B NAME-B-8
    20
    NAME-B NAME-B-9
    21
    NAME-B NAME-B-10
    22
    NAME-B NAME-B-11
    23
    NAME-B NAME-B-12
    24
    NAME-C NAME-C-1
    25
    NAME-C NAME-C-2
    26
    NAME-C NAME-C-3
    27
    NAME-C NAME-C-4
    28
    NAME-C NAME-C-5
    29
    NAME-C NAME-C-6
    Sheet: Sheet2
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change data structure using Formula or Power Query ( Get & Transform)
    By chullan88 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-04-2017, 02:58 AM
  2. Help on Ideas of how to transform data from a vertical to more horizontal layout
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-29-2016, 03:02 AM
  3. transform into do until formula
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2015, 04:41 PM
  4. [SOLVED] sumproduct formula for horizontal data
    By Jules Pop in forum Excel General
    Replies: 7
    Last Post: 08-08-2014, 05:25 AM
  5. Copying formula down with horizontal source data
    By NDF in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 05-26-2013, 10:38 PM
  6. Help with a macro formula to convert horizontal data into veritical data
    By shapenote1 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-26-2013, 06:27 PM
  7. [SOLVED] Copying and pasting Horizontal Data to Horizontal cells
    By jjin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2013, 01:14 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1