+ Reply to Thread
Results 1 to 3 of 3

Selectively merge cells keeping all data

  1. #1
    Registered User
    Join Date
    03-07-2022
    Location
    Colorado
    MS-Off Ver
    office 365
    Posts
    2

    Selectively merge cells keeping all data

    Hello All ,

    Looking for a solution to merge cells selective and keep data from both, then shift the remaining rows cell to the left.
    This process is to align data columns were some rows have different cell counts. Any (B) cells with an x need to be merged with (A) preserving data. All '0A' data needs to line up.

    The intent is to post process RS485 hex data . The messages will have text descriptors that sometimes use two consecutive row cells. This causes the actual raw hex data to offset column data for that row.
    I need the open frame values '0A' and subsequent data to column align.

    Merge it.JPGMerge it After.JPG
    Attached Files Attached Files
    Last edited by msteffes; 03-08-2022 at 04:27 PM.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,178

    Re: Selectively merge cells keeping all data

    Hello & Welcome to the Forum,

    I suspect we could do this with concatenate, but could you please update your file with two tabs. A before and after and the why!
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    03-07-2022
    Location
    Colorado
    MS-Off Ver
    office 365
    Posts
    2

    Re: Selectively merge cells keeping all data

    After doing some web searches, this seems to do the job. Not that tough just need to get more VBA under my belt.

    Please Login or Register  to view this content.
    Last edited by msteffes; 03-11-2022 at 05:49 PM.

+ 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. [SOLVED] How to selectively copy the content of some cells without empty cells
    By thomasboivin in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 01-17-2020, 09:51 AM
  2. Protecting Cells that can be changed selectively
    By alex.l_91 in forum Excel General
    Replies: 0
    Last Post: 01-29-2013, 11:14 PM
  3. Replies: 3
    Last Post: 06-28-2012, 09:05 AM
  4. How do you selectively merge two workbooks?
    By GeekOnAmission in forum Excel General
    Replies: 3
    Last Post: 03-15-2011, 12:17 PM
  5. Selectively prevent cells from updating
    By RobertArbon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2009, 09:18 AM
  6. sum cells in same column selectively based on value of different .
    By Carlos García in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2006, 05:40 PM
  7. [SOLVED] How do I merge two cells but keeping all contents in Excell?
    By gysl in forum Excel General
    Replies: 2
    Last Post: 11-01-2005, 04:05 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06041 seconds
  • Memory Usage 8,944KB
  • Queries Executed 16 (?)
More Information
Template Usage (35):
  • (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)bbcode_code
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (3)memberaction_dropdown
  • (1)navbar
  • (3)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (3)postbit_legacy
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (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 (49):
  • 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_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1