+ Reply to Thread
Results 1 to 1 of 1

Transpose Attribute Field Titles to precede SKU Values, then assign HTML tags

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    NY/NJ Metro
    MS-Off Ver
    Excel 2007
    Posts
    2

    Transpose Attribute Field Titles to precede SKU Values, then assign HTML tags

    I received numerous spreadsheets of data (each containing thousands of products) with the product attributes that title each column of values for a broad spectrum of products. I need a macro to transform the format for a website.

    If you can only assist in helping to transpose data to sheet2, that would be greatly appreciated.

    I would like to preserve the row associated with the product ID but transpose the attribute title (title preceded by <b> followed by “:</b>”- without quote marks) to precede the value (VAL). Because the spreadsheet is a consolidation of many different product types, there are many empty fields because values may not exist for a specific SKU.

    These attributes are interspersed with columns where I would prefer to keep the structure intact (not transpose title). Prior to running the macro, I can highlight columns that I do not want translated but would accept any suggestion. The non-translated columns would appear after the last ATT/VAL set and should remain a uniform column, meaning the column location does not shift by SKU (row). The raw data would be provided on Sheet1 and the transposed data (new structure) would occur on Sheet2, where my example is shown.

    As the last step which I would prefer to manually activate as a separate routine on Sheet 2, is to have HTML tags applied to the translated attributes. I have listed the code, noting the repeating steps and provided sample code. These are shown on Sheet 2 between columns BW-CE

    I have attached a sample sheet with raw data which I have transformed the first row to demonstrate (on Sheet 2) the desired output. As you can see, it is difficult to pre-determine the number of Att/Val combinations each SKU would yield. I created 30 ATT/VAL fields but don't know how many any product will populate.

    Thank you in advance for your assistance.
    Attached Files Attached Files
    Last edited by fastener; 03-21-2013 at 04:42 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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