+ Reply to Thread
Results 1 to 2 of 2

How to transform my data into Pivot Table friendly data?

  1. #1
    Forum Contributor
    Join Date
    03-12-2012
    Location
    Singapore
    MS-Off Ver
    MS 365
    Posts
    532

    How to transform my data into Pivot Table friendly data?

    Hi, my operation key in their data using Tab+Enter way (see attached).
    How do i transform the data into pivot table friendly format? I tried using the QUery editor, but failed.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: How to transform my data into Pivot Table friendly data?

    This was probably the solution
    Attached Files Attached Files

+ 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. Pivot Table Hyperlink with Friendly name VBA
    By JoKerr in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-26-2017, 12:29 PM
  2. Get & Transform # Pivot/Transpose data
    By Ohhaa in forum Excel General
    Replies: 3
    Last Post: 07-03-2017, 11:23 AM
  3. [SOLVED] Transform Data From Pivot Style to a Table Style
    By The_Snook in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-18-2016, 04:13 AM
  4. [SOLVED] Transform semi-structured bloomberg data into pivottable table
    By jasonleewkd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2013, 08:10 AM
  5. VBA help converting data to a pivot table friendly format.
    By JT314 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-21-2012, 01:52 PM
  6. [SOLVED] Re-arrange a worksheet range to a pivot-friendly table?
    By Alabaster in forum Excel General
    Replies: 4
    Last Post: 12-01-2011, 09:19 AM
  7. Advice on User-Friendly Pivot Table Question
    By pdxguy_2188 in forum Excel General
    Replies: 0
    Last Post: 03-03-2011, 07:14 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