Evening,
What I am seeking to do is combine columns (T,V,XZ,AB,AD,AF), each one has a column to the right, that as a number (which is a quantity for the column to the left). I am seeking to have a pivot table, in which the items combine like item names get the total based on the qty to be based off the qty columns. I have attached a sample for reference.
Last edited by Ajaxs87; 06-24-2023 at 05:27 PM.
You didn't really explain/show what your expected results should look like. So.. a guess. If not SHOW us what you want.
=WRAPROWS(TOCOL(T2:AG10,3),2)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I think the OP wants to sum on unique values (like a pivot table). I tried this morning, but I am still struggling to get BYROW and LAMBDA to work for me!
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
maybe yes... in which case:
=LET(A,T2:AG10,B,WRAPROWS(TOCOL(A,3),2),C,UNIQUE(INDEX(B,,1)),D,MAP(C,LAMBDA(x,SUM(IF(INDEX(B,,1)=x,INDEX(B,,2),0)))),HSTACK(C,D))
My apologies for the lackluster explanation. Yesterdays workload had my brain on mashed potatoes apparently. I am attaching a workbook, with an explanations sheet to help with explaining. Thank you all for your time and efforts.
Try this,
Please Login or Register to view this content.
Re: Combine multiple columns of value and get their totals from offset columns to the righ
just for fun with Power Query and Pivot
Item Sum of Qty 5B S147 S573 SA712 SA713 SA734 Grand Total
Thank you all for your wisdom and knowledge. sandy666, I guess I am going to have to look at the PowerQuery link below that you have.
I highly recommend itOriginally Posted by Ajaxs87
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks