+ Reply to Thread
Results 1 to 11 of 11

Need help converting a table

  1. 01-02-2023, 05:52 PM #1
    sbrass
    sbrass is offline
    Registered User
    Join Date
    01-02-2023
    Location
    SF, CA
    MS-Off Ver
    MS OFFICE 365
    Posts
    8

    Need help converting a table

    Hello,

    I'm having difficulty convert a table.

    I currently have a table set up like the following:

    Rev1.PNG

    But I would like it set up like this:

    Rev2.PNG

    Does anyone have any ideas on how to?
    Reply With QuoteRegister To Reply
  2. 01-02-2023, 06:00 PM #2
    Keebellah
    Keebellah is offline
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: Need help converting a table

    I don't see the problem if it's a one-time action
    Copy a row and paste as tranposed to another location and do it for all
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you
    Reply With QuoteRegister To Reply
  3. 01-02-2023, 06:03 PM #3
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,434

    Re: Need help converting a table

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 01-02-2023, 06:29 PM #4
    sbrass
    sbrass is offline
    Registered User
    Join Date
    01-02-2023
    Location
    SF, CA
    MS-Off Ver
    MS OFFICE 365
    Posts
    8

    Re: Need help converting a table

    Apologies for not attaching a example.

    I could just manually update the file each month with revenue but I wanted to see if anyone knew a different approach. There can be upwards of 300 programs running at once so i prefer not to work this manually.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 01-02-2023, 06:31 PM #5
    sbrass
    sbrass is offline
    Registered User
    Join Date
    01-02-2023
    Location
    SF, CA
    MS-Off Ver
    MS OFFICE 365
    Posts
    8

    Re: Need help converting a table

    Original is on the left side of the file and the wanted output is the right side
    Reply With QuoteRegister To Reply
  6. 01-02-2023, 06:38 PM #6
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Need help converting a table

    with Power Query

    Program September 22 October 22 November 22 December 22 Program Revenue Month
    A
    28,980
    70,521
    26,299
    42,311
    		 A
    42311
    		 December 22
    B
    60,219
    67,265
    30,621
    47,480
    		 B
    47480
    		 December 22
    C
    47,817
    47,817
    47,817
    72,153
    		 C
    72153
    		 December 22
    D
    68,563
    43,324
    74,006
    40,492
    		 D
    40492
    		 December 22
    A
    26299
    		 November 22
    B
    30621
    		 November 22
    C
    47817
    		 November 22
    D
    74006
    		 November 22
    A
    70521
    		 October 22
    B
    67265
    		 October 22
    C
    47817
    		 October 22
    D
    43324
    		 October 22
    A
    28980
    		 September 22
    B
    60219
    		 September 22
    C
    47817
    		 September 22
    D
    68563
    		 September 22 


    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sandy666; 01-02-2023 at 06:43 PM. Reason: file added
    Reply With QuoteRegister To Reply
  7. 01-04-2023, 07:57 PM #7
    sbrass
    sbrass is offline
    Registered User
    Join Date
    01-02-2023
    Location
    SF, CA
    MS-Off Ver
    MS OFFICE 365
    Posts
    8

    Re: Need help converting a table

    Thanks a lot!
    Reply With QuoteRegister To Reply
  8. 01-04-2023, 08:06 PM #8
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Need help converting a table

    You are welcome

    if the problem is solved, mark the thread as SOLVED (top above your first post - Thread Tools)
    Reply With QuoteRegister To Reply
  9. 01-04-2023, 08:34 PM #9
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,419

    Re: Need help converting a table

    Here is a solution with a formula:

    Please try
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by HansDouwe; 01-05-2023 at 12:35 AM.
    Reply With QuoteRegister To Reply
  10. 01-04-2023, 11:29 PM #10
    sbrass
    sbrass is offline
    Registered User
    Join Date
    01-02-2023
    Location
    SF, CA
    MS-Off Ver
    MS OFFICE 365
    Posts
    8

    Re: Need help converting a table

    wow that really interesting to look at. What do you even call what you did there?
    Reply With QuoteRegister To Reply
  11. 01-05-2023, 12:44 AM #11
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,419

    Re: Need help converting a table

    Thanks for the feedback and rep .
    I created a table with MAKEARRAY.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. macro VBA to exclude first table while converting table to text
    By sshishirkumar in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2013, 05:29 AM
  2. Converting a 2-row table into a multi-column table
    By kle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2013, 08:49 PM
  3. [SOLVED] Converting Table to Range, Then Back to Table
    By Gard5096 in forum Excel General
    Replies: 1
    Last Post: 01-23-2013, 06:03 PM
  4. converting table to csv.
    By steve1987 in forum Excel General
    Replies: 5
    Last Post: 06-12-2012, 04:30 PM
  5. converting a table to a list
    By jhelliar in forum Excel General
    Replies: 2
    Last Post: 11-17-2011, 04:29 PM
  6. Converting row to table, then repeating (copying) table...
    By speede541 in forum Excel General
    Replies: 3
    Last Post: 09-16-2008, 05:13 AM
  7. Converting from one table to another
    By function in forum Excel General
    Replies: 7
    Last Post: 10-09-2007, 08:56 AM
  8. help converting table structure
    By Chris Barnett in forum Excel General
    Replies: 2
    Last Post: 09-29-2005, 04:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1