+ Reply to Thread
Results 1 to 2 of 2

Formatting multiple rows into columns

  1. #1
    Registered User
    Join Date
    Boulder, CO
    MS-Off Ver
    Excel 2010

    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
    Cibolo, TX
    MS-Off Ver
    Excel 2016

    Re: Formatting multiple rows into columns

    Hello & Welcome to the Forum,

    Does this help?

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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