+ Reply to Thread
Results 1 to 3 of 3

List with 2 variables

  1. #1
    Registered User
    Join Date
    05-07-2019
    Location
    Kristiansand
    MS-Off Ver
    Office 2019
    Posts
    1

    List with 2 variables

    I have a long list with many values with object temperature and ambient temperature.
    I want all object temperatures to come in succession in a row and all of the ambient temperatures come in another row.
    ambient temperature stands on odd colonies and object tempereature stands on some columns. How can I do this?

    Skjermbilde (369).png

    as in this picture, but now I have just taken and copied the values over to the right cell but doing so with 25000 values takes a very long time
    Attached Files Attached Files
    Last edited by Harald93; 05-07-2019 at 06:03 AM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: List with 2 variables

    Hi, and welcome to the forum

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.


    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: List with 2 variables

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Multiple variables to create a list
    By Tarontagosh in forum Excel General
    Replies: 1
    Last Post: 05-03-2017, 08:50 AM
  2. [SOLVED] Get list of variables
    By plans in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2016, 06:28 PM
  3. Replies: 3
    Last Post: 06-14-2014, 03:05 PM
  4. Multiple Variables for Lookup and List
    By capitalsfan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-25-2013, 05:20 PM
  5. Looking up results from a list with two variables
    By damage in forum Excel Formulas & Functions
    Replies: 24
    Last Post: 08-13-2013, 07:11 AM
  6. Sorting using a predetermined list of variables
    By cheddarthief in forum Excel General
    Replies: 2
    Last Post: 09-15-2011, 08:52 AM
  7. List of variables
    By w_lred in forum Excel General
    Replies: 1
    Last Post: 11-21-2008, 06:26 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