Results 1 to 4 of 4

How Can I move Raw Data Into Separate Columns

Threaded View

  1. #1
    Registered User
    Join Date
    05-02-2020
    Location
    Canada, BC
    MS-Off Ver
    2016
    Posts
    2

    How Can I move Raw Data Into Separate Columns

    Hi, I have some lab data that I need to organize. I have two probes collecting data points and they measure at different index cycles. I would like to take the raw data and organize them into separate columns where the data from the two probes are separated out based on the index cycle. For example all the data collected on index cycle one are separated out from the data collected in index cycle 5 and so on. I have included an excel file with some sample data to better illustrate what I am trying to achieve.

    I tried using VLOOKUP to separate the data based on the index cycle but it is not giving me the results I want. Some columns are giving me wrong values. Is there a simpler way to solve this problem?

    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. [SOLVED] move data from rows into separate columns
    By augr in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-28-2019, 08:20 PM
  2. [SOLVED] Move Data from Multiple Rows to One Row in Separate Columns
    By djpinson in forum Excel General
    Replies: 2
    Last Post: 05-13-2019, 09:20 AM
  3. [SOLVED] Move customer data in separate workbooks
    By sizzi09 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2014, 06:50 PM
  4. Macro to move data from one sheet to another and separate 1 cell into 2
    By rp1783 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-26-2014, 07:18 PM
  5. [SOLVED] To move Data rows to columns against one cell so can write separate SQL insert statments
    By hadster016 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2014, 09:52 AM
  6. Macro edit to move data to TWO separate sheets
    By dlab85 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-16-2012, 01:00 PM
  7. Replies: 7
    Last Post: 09-07-2011, 02:30 PM

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