+ Reply to Thread
Results 1 to 2 of 2

Formatting multiple rows into columns

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    Boulder, CO
    MS-Off Ver
    Excel 2010
    Posts
    1

    Formatting multiple rows into columns

    Hi everyone,

    My column A lists categories while columns B, and C list the data for the category. This pattern is repeated every 4 rows for approximately 150 sets of data. How would I go about moving the categories from column A into Row 1 and the data from Columns B and into rows while maintaining the data's integrity and only representing the data from Column C one time.

    Dataset A
    ----------------------------------
    Fname Bob Male
    Lname Smith Male
    Address 1234 Street Male
    Phone 555 555 5555 Male
    Fname Jill Female
    Lname Wilson Female
    Address 3322 Ave Female
    Phone 333 333 3333 Female


    Desired Outcome
    -----------------------------------
    Fname Lname Address Phone ***
    Bob Smith 1234 Street 555 555 5555 Male
    Jill Wilson 3322 Ave 333 333 3333 Female

    I've attached an example set of the data: excelhelp.xlsx

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,095

    Re: Formatting multiple rows into columns

    Hello & Welcome to the Forum,

    Does this help?

    Please Login or Register  to view this content.
    HTH
    Regards, Jeff

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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