+ Reply to Thread
Results 1 to 2 of 2

Can someone help me to manipulate these data?

  1. #1
    Registered User
    Join Date
    03-07-2013
    Location
    Germany
    MS-Off Ver
    Excel 2003
    Posts
    1

    Can someone help me to manipulate these data?

    Hi, It's kinda hard to explain what I want to achieve here.
    I have repeatedly parameters and want to make them headers with their corresponding values of course. Can someone teach me how?
    Thank you

    OLD:
    name parameters value
    a bts id 43827428
    a type Opti
    b bts id 73874342
    b type Flexi
    c bts id 74384928
    c type Indoor
    d bts id 94839743
    d type Indoor
    e bts id 39494904
    e type Opti

    NEW:
    name bts id type
    a 43827428 Opti
    b 73874342 Flexi
    c 74384928 Indoor
    d 94839743 Indoor
    e 39494904 Opti

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: Can someone help me to manipulate these data?

    I'm not sure I can teach you how but if you put together a dummy workbook with the same data layout I can put together a macro that will do it for you.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ 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