+ Reply to Thread
Results 1 to 4 of 4

Need help with pulling specific data from two rows and putting it into one single row

  1. #1
    Registered User
    Join Date
    04-01-2013
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    2

    Exclamation Need help with pulling specific data from two rows and putting it into one single row

    Hello,

    Need some help...

    I have 2 columns of data in Excel 2010 that includes configurations for equipment in our network. The data I am looking to put onto a single row is on various rows throughout the configurations:

    Row 1, Column A: Identifier ; Row 1 Column B: 'Specific Company Name'
    Row 37, column A: Outbound ; Row 37 Column B: 'Specific Value'
    Row 101, Column A: Identifier ; Row 1 Column B: 'Specific Company Name'
    Row 137, column A: Outbound ; Row 37 Column B: 'Specific Value'

    I need to get the data in lines 1 and 37 into one row, and the data from row 101 and 137 into another row. The data in column A could be repeated multiple times throughout the sheet (it is a header for all intents and purposes), and the data in column B could be unique for the data in row 1 and 101, however the data in row 37 and 137 may be the same... Is there an easy to get this done? I have tried pivot tables, but it combines non-unique values, and sorts out of the config order (for instance, it returns data from rows 1 and 101, then data from rows 37 and 137)... If I could figure out how to get it to stop sorting that way, OR figure out a way to get the data to be in the same row, that would be great...

    Thanks in advance

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Need help with pulling specific data from two rows and putting it into one single row

    Hi

    Is the data always going to have the same spacing? How is the "Identifier" structured? Is there a way to determine the identifier by its structure? Where do you want the output to go?

    How about an example file that contains representative data (matches format, but does not show anything sensitive) and also contains what the output for your example data should look like.

    rylo

  3. #3
    Registered User
    Join Date
    04-01-2013
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Need help with pulling specific data from two rows and putting it into one single row

    File Attached.. sample audit.xlsx

  4. #4
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: Need help with pulling specific data from two rows and putting it into one single row

    Hi

    sorry, but example file doesn't clear anything up for me. Can you provide some explanations.

    rylo

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.05920 seconds
  • Memory Usage 8,900KB
  • Queries Executed 15 (?)
More Information
Template Usage (31):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (4)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (4)postbit_legacy
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (47):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1