Results 1 to 6 of 6

Help with reorganizing raw data on a different sheet

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2017
    Location
    United States
    MS-Off Ver
    2016
    Posts
    3

    Help with reorganizing raw data on a different sheet

    Hello,

    Note: I attached my file because my explanation of my problem may be confusing.

    I have raw data which is organized with the Item # and Process listed vertically and the Date listed horizontally. I would like to show this data with the Item # listed vertically and the Date and Process listed horizontally. I would like the date to be repeated with each step in the process to each item. Currently, the date is only listed once because the Item # and Process are listed vertically. Each unique date will go from being listed once per column to being repeated 5 times (once for each of the 5 steps). I will manually build this part of the working sheet. I need a function that changes the numbers from running vertically to horizontally. I manually typed in some numbers in my file which may give you a better idea of my intention. Basically, I think I am trying to transpose the numbers, but I don't think the transpose function will work with how I need my data organized. Please see my attached sample file.

    Thank you!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Reorganizing Data
    By TristanL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2014, 04:13 PM
  2. Reorganizing Data
    By nav505 in forum Excel General
    Replies: 5
    Last Post: 02-23-2013, 04:25 PM
  3. Reorganizing Data
    By nav505 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-23-2013, 01:13 PM
  4. [SOLVED] Reorganizing data-please help
    By pahari75 in forum Excel General
    Replies: 7
    Last Post: 01-25-2013, 01:32 AM
  5. Reorganizing data from another sheet
    By cadamhill in forum Excel General
    Replies: 7
    Last Post: 04-05-2011, 09:54 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