+ Reply to Thread
Results 1 to 6 of 6

power query editor - unpivot?

  1. #1
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    power query editor - unpivot?

    Hi guys
    Don't know how to work with this but i think it is what i need, not sure.
    I have a big table with all my clients and the personal attached to them, responsable to them (they're called Tec).
    It is supposed to have just one person for each client but i see i have many times 3, 4 or even 5.
    In query editor, after i have cleaned the database and all, also after those split columns for each person, now i have to many fields.
    I have the client name, number, date, code for this, code of that, and....tec1, tec2, tec3, etc, due to my split column.
    The question is simple: How can i have just one tec field among all those columns?
    Let me attach my file.
    Many thanks for your answers
    Best regards
    Pedro
    P.S. I have excel 365
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    11-06-2013
    Location
    Bedfordshire, United Kingdom
    MS-Off Ver
    Excel 2012
    Posts
    4

    Re: power query editor - unpivot?

    Have you attached the file?

  3. #3
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Re: power query editor - unpivot?

    yes. It's called unpivot.jpeg

  4. #4
    Registered User
    Join Date
    11-06-2013
    Location
    Bedfordshire, United Kingdom
    MS-Off Ver
    Excel 2012
    Posts
    4

    Re: power query editor - unpivot?

    I guess the issue I and anyone will have is that you have split by delimiter creating multiple users so
    If I look at Row 3 in you jpg I have to guess that before the split Tec1 consisted of 5 or more names.

    If you made the actual file available and not a screenshot we would be able to follow through what you are trying to do.
    if it is just that there are now duplicate records add an index column before you start then remove duplicates over the index column. But without a clearer idea of what you are doing it is very difficult to solve.
    Last edited by martinl; 09-07-2016 at 07:58 AM.

  5. #5
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Re: power query editor - unpivot?

    Hello Martinl
    Tks for your reply.
    Yes, that jpeg is an image of what i've done so far, that means, i've splited 5 or 6 times a column till it's ok.
    Now the rule to unsplit i don't know cose, i've tried and it does not show what i would like.
    The thing is that I have a client with, in this case, 5 tec or 6 or 4. Each one has a % of working.
    I know how much is worth my client. But i would like to know what's worth the job of each tec for that cliente, and each tec with all clients.
    Before i had client name, number, code, company, group, tec %, state and periode.
    Now i have client name, number, code, company, group, state, periode, Tec1, %1, Tec2, %2, tec3, %3, tec4, %4....
    Hope i could help
    Many thanks
    Pedro

  6. #6
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    174

    Re: power query editor - unpivot?

    Guys,
    I'm very sorry to have wasted your time. I don't need to unpivot.
    Many thanks
    Best regards
    Pedro

+ 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] power query
    By juanda92 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2016, 08:56 AM
  2. VBA and Power Query
    By Brawnystaff in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-16-2015, 05:10 AM
  3. [SOLVED] How to set a power point presentation as an object (from the excel vba editor)
    By Jonas1503 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2014, 08:08 AM
  4. power point query
    By jrmehta in forum Excel General
    Replies: 1
    Last Post: 10-11-2010, 01:58 AM
  5. [SOLVED] QUERY: auto clean VB code editor?
    By KevinGPO in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2005, 07:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1