Results 1 to 18 of 18

Power Query Transformation of Unstructured Data Table

Threaded View

  1. 05-24-2023, 08:23 AM #1
    richy89
    richy89 is offline
    Registered User
    Join Date
    07-11-2022
    Location
    Sydney
    MS-Off Ver
    2016
    Posts
    31

    Power Query Transformation of Unstructured Data Table

    Hi All,

    I have attached a file showing a table with multiple headers and a format that is rather difficult for me to transform in Power Query to rows. Hoping someone here can assist.
    I provided desired outcome as well.

    Cheers
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Power Query: Efficient Data Transformation Required
    By m_kerr in forum Excel General
    Replies: 12
    Last Post: 12-20-2021, 12:03 PM
  2. [SOLVED] Power Query transformation of unrecognizable date/time format in column with various input
    By Marbleking in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-20-2021, 02:15 PM
  3. Sorting Pivot Table Pulling from Power Query Data Table
    By perkyparker in forum Office 365
    Replies: 1
    Last Post: 05-22-2021, 03:02 PM
  4. [SOLVED] Help to extract unstructured data into a table
    By josephteh in forum Excel General
    Replies: 1
    Last Post: 09-29-2020, 03:57 AM
  5. Power Query: Simple Table Transformation
    By andrewc in forum Excel General
    Replies: 1
    Last Post: 09-24-2020, 06:12 AM
  6. [SOLVED] Power Query Date Transformation
    By Moggzzz in forum Excel General
    Replies: 2
    Last Post: 03-21-2018, 02:47 PM
  7. Data transformation using Formula or Power Query
    By chullan88 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-18-2017, 09:59 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1