Results 1 to 4 of 4

Help with list.sum formula (custom column) to finish data transformation

Threaded View

  1. 08-24-2021, 10:14 AM #1
    sunboy
    sunboy is offline
    Forum Contributor
    Join Date
    07-06-2020
    Location
    zimbabwe
    MS-Off Ver
    Excel 365
    Posts
    478

    Help with list.sum formula (custom column) to finish data transformation

    Hi

    I'm kindly asking for the help to finish data transformation. I have done up to Add index column. My problem is to construct a List.Sum formula on custom column formula. See the attached excel sheet. if possible follow the step I have done so that I learn, if you restart the process I might not understand it, since I'm still learning Power query.

    Thank you.

    Regards,

    Sunboy
    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. Complex table transformation - Insert rows between 2000 rows and move column data to row d
    By justayellowbusman2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2019, 09:19 PM
  2. Data transformation using Formula or Power Query
    By chullan88 in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 11-18-2017, 09:59 AM
  3. To automate the transformation of a data column to a two dimensional table
    By geniusufo007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-27-2017, 11:54 PM
  4. Combining a data validation list with a custom formula (including error message)
    By robgron in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-17-2014, 07:23 AM
  5. Combining a data validation list with a custom formula (including error message)
    By robgron in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-16-2014, 09:55 AM
  6. [SOLVED] Address list transformation
    By MaximH in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-24-2013, 09:58 AM
  7. Data Validation List and Custom formula in 1 cell
    By murugavelmsc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-11-2013, 02:50 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