+ Reply to Thread
Results 1 to 7 of 7

purchased excel file has stacked alternating rows to create a single record..msword label

  1. #1
    Registered User
    Join Date
    07-29-2013
    Location
    Orlando FL
    MS-Off Ver
    Excel 2010
    Posts
    5

    purchased excel file has stacked alternating rows to create a single record..msword label

    Tester checks template2.xlsxThis issue has stumped several local experts
    I have a Excel file with 3000 records with staggered rows of information so a1 has name field b1 is blank but b2 has address field b3 has city b4 has state but a5 has zip code. b2 cells are wrapped so that if address is too long it will wrap to cell a2

    It is easy enough to read as all records are contained in two rows.

    It is a nightmare to create MSWORD labels as the fields are difficullt to define.

    How could I modify the existing data base to make a single row contain all active cells (9 cells in row 1 and 8 or more cells in row 2 because of wraps)

    I will be glad to share this confusing file for purpose of clarity in seeking solutions.
    WSCOOK
    Last edited by wscook; 07-29-2013 at 11:10 AM. Reason: adding a file

  2. #2
    Forum Contributor
    Join Date
    08-08-2005
    Location
    Kansas, USA
    MS-Off Ver
    2016
    Posts
    293

    Re: purchased excel file has stacked alternating rows to create a single record..msword la

    Can you just concatenate all the cells for a single record, then parse?

    Might help if you supplied a sample file.

  3. #3
    Registered User
    Join Date
    07-29-2013
    Location
    Orlando FL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: purchased excel file has stacked alternating rows to create a single record..msword la

    Tester checks template2.xlsx I think that I have attached the file

  4. #4
    Registered User
    Join Date
    07-29-2013
    Location
    Orlando FL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: purchased excel file has stacked alternating rows to create a single record..msword la

    Please advise if you were able to review submitted file
    Thanks

  5. #5
    Registered User
    Join Date
    07-29-2013
    Location
    Orlando FL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: purchased excel file has stacked alternating rows to create a single record..msword la

    over 100 views and only one reply, not very encouraging

  6. #6
    Registered User
    Join Date
    07-29-2013
    Location
    Orlando FL
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: purchased excel file has stacked alternating rows to create a single record..msword la

    Thanks to all who viewed but I will move my query to commercial group

  7. #7
    Forum Contributor
    Join Date
    08-08-2005
    Location
    Kansas, USA
    MS-Off Ver
    2016
    Posts
    293

    Re: purchased excel file has stacked alternating rows to create a single record..msword la

    Sorry for the delay, I don't get back here every day.

    Looking at your file, it appears as if each record consists of 2 rows; using rows 2:3 as a sample, A2 Is Vendor Name, B2 is some undefined number, C2 is is invoice#, D2 is Check Date, E2 is Check No, F2 is Amount, A3 is the Address Line 2, B3 is Address Line 1, C3 is City, D3 is State, and E4 is Zip.

    If this pattern follows thruout the file, then it should be relatively simple to read these into arrays and then output them in some more desireable format. This could be donevia macros. An alternate approach could be with formulae. I have attached a file with a formulaic approach. Does that do what you are after? I combined the address lines into one cell, but you could easily separate them as necessary. Once the formulae were in place in row 2, I just copied rows 2:3 down to get the result as shown. I only did this for the first several entruies, so if this is what you're after, just repeat for the remainder of the file.
    Attached Files Attached Files

+ 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. Replies: 1
    Last Post: 05-30-2013, 10:03 AM
  2. [SOLVED] Create alternating rows
    By Scibola in forum Excel General
    Replies: 2
    Last Post: 04-09-2013, 04:19 PM
  3. Create a single record with total sum of sales
    By RaymonGompelman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2013, 11:03 AM
  4. Open MSWord from Excel, merge with current Userform record, save and close Word.
    By jamieswift1977 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2012, 05:28 AM
  5. Replies: 1
    Last Post: 10-05-2005, 01:05 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