+ Reply to Thread
Results 1 to 3 of 3

convert data with format feature-value-unit into feature(header) with feature+value(row)

  1. #1
    Registered User
    Join Date
    01-31-2020
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    8

    convert data with format feature-value-unit into feature(header) with feature+value(row)

    Hello,

    I would like to convert data with format feature(header)-value(header)-unit(header) into feature(header) with value+unit(row).

    But it's a little hard to discribe in plain text so I made an example file wich i'll send as an attachement.
    So i would like to convert the green cells into the blue one's.

    Because I have thousands of features to convert it's not possible to do it manualy.
    If someone could help me out, that would be great !
    Attached Files Attached Files
    Last edited by tzer007; 01-31-2020 at 10:14 AM.

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    1,937

    Re: convert data with format feature-value-unit into feature(header) with feature+value(ro

    Hi. Give this code a try:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Registered User
    Join Date
    01-31-2020
    Location
    Belgium
    MS-Off Ver
    2016
    Posts
    8

    Re: convert data with format feature-value-unit into feature(header) with feature+value(ro

    Thanks WideBoyDixon !!!

    This code works perfect.

    You've got ya self another big fan,
    thanks mate !

+ 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] Removed feature: Data validation from/xl/worksheets/sheet1.xml part
    By Gaellus in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-01-2021, 02:21 PM
  2. Macro need Arranging column data in Quiz format using transpose and Text to Column Feature
    By successramesh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-16-2014, 02:58 AM
  3. Replies: 3
    Last Post: 06-20-2014, 04:50 PM
  4. [SOLVED] Data validation with the table feature on another worksheet dosent work
    By Masun in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-29-2013, 06:54 AM
  5. vba to reproduce data..validation retry button feature:
    By larryagrossman in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-11-2012, 11:28 PM
  6. Can I use the autofilter feature to limit data for a pivot chart?
    By Randy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-19-2005, 01:30 PM
  7. [SOLVED] Conditional Format Feature
    By carl in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-26-2005, 05:15 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