+ Reply to Thread
Results 1 to 6 of 6

Using transpose or other way to make a table

  1. #1
    Registered User
    Join Date
    02-02-2018
    Location
    TURKEY
    MS-Off Ver
    2013
    Posts
    35

    Using transpose or other way to make a table

    Hello,

    is there any chance to make the table in sheet "PL_FORM" transposed to the table in sheet "AS_FORM" automatically? I've tried everything I know but nothing does the trick

    Please help me

    Thanks in advance,

    Cheers.
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,933

    Re: Using transpose or other way to make a table

    Using Power Query/Get and Transform which is part of Excel 2013.

    Mcode

    Please Login or Register  to view this content.
    You will have to unmerge cells as I have in your example. File attached.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-02-2018
    Location
    TURKEY
    MS-Off Ver
    2013
    Posts
    35

    Re: Using transpose or other way to make a table

    Perfectly worked! Actually I didn't know that there's something called Power Query in Excel, I learned now thanks to you!!
    but I have this problem now:
    after I make the query and load the produced table made by Power Query, when I make some changes in values or Box Numbers I have to redo the process and copy/paste the new produced table by Power Query, is there any way to make Power Query refresh by itself on my target sheet without producing a new sheet in by Power Query?

    I really really thank you very much.

  4. #4
    Valued Forum Contributor BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    944

    Re: Using transpose or other way to make a table

    There is solution based on formulas
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-02-2018
    Location
    TURKEY
    MS-Off Ver
    2013
    Posts
    35

    Re: Using transpose or other way to make a table

    Hello BMV,

    I would like to thank you very very much for your efforts, I learned new functions which I didn't know before.

    Thanks again for your help.

    Reputation added.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    17,933

    Re: Using transpose or other way to make a table

    If you use the refresh button on the Data Tab after updating the original data, it should update the query automatically. Thanks for the Rep

+ 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. Using transpose or other way to make a table
    By Mark00963 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-22-2019, 03:25 PM
  2. [SOLVED] Using transpose or other way to make a table
    By Mark00963 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 07-07-2019, 11:20 AM
  3. To transpose or not to transpose? What decides? Table / Array?
    By LIL2606 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-19-2019, 01:28 PM
  4. Replies: 4
    Last Post: 08-21-2018, 09:24 AM
  5. Transpose Help; I need to make every 4 rows into one row with 4 columns! Please!
    By Robles4242 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-21-2015, 11:46 PM
  6. transpose column to a range calculate and transpose to new table loop
    By moshro1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-02-2015, 10:52 AM
  7. [SOLVED] How to transpose two tables to make a one?
    By Mirisage in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 10-17-2014, 10:24 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