+ Reply to Thread
Results 1 to 3 of 3

Transform range

  1. #1
    Registered User
    Join Date
    02-01-2022
    Location
    London
    MS-Off Ver
    Microsoft® Excel® for Microsoft 365 MSO (Version 2111 Build 16.0.14701.20278) 32-bit
    Posts
    27

    Transform range

    I have some data that has come in a messy format (see attached).

    I need to clean it into a format, that will make it accessible for Power BI.

    I need to unpivot the date and values, so there would be a column for date, hours worked, cost.
    Attached Files Attached Files
    Last edited by samparker095; 05-27-2022 at 09:06 AM. Reason: Clicked enter to quick

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Transform range

    I used this macro on a part of your data.


    Please Login or Register  to view this content.

    See the attached file, with the result on sheet output.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,810

    Re: Transform range

    Here is a solution using Power Query which you can implement through Power BI

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Transform specific range into entire column range
    By jeriss in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-09-2022, 06:51 PM
  2. [SOLVED] Get & Transform: Changing Data Range for Query
    By andrewc in forum Excel General
    Replies: 2
    Last Post: 09-15-2020, 03:39 AM
  3. Transform Single Column to Range
    By agentx95 in forum Excel General
    Replies: 5
    Last Post: 04-05-2019, 05:58 AM
  4. Replies: 1
    Last Post: 01-16-2018, 02:28 AM
  5. Passing a variable range into fourier transform
    By waciavarra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2015, 02:29 PM
  6. Transform a 365 cells range value into 12 rows / 31 col. range?
    By nikenis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2013, 10:49 AM
  7. Help with Transform Range
    By beezer2484 in forum Excel General
    Replies: 1
    Last Post: 01-28-2013, 09:23 PM

Tags for this Thread

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