Excel formula

[Ram Chandran]

Hi Experts,

Can you please help me to sort the excel task with formual or even VBA.
Please find the attached sheet.

Thanks in advance.

 

[vletm]

Please take a few minutes to read this list of Rules, Procedures and Etiquette's for posting here at the Chandoo.org Forums.

Below is full part of
How to get the Best Results at Chandoo.org

• Use Relevant words in the Title and in the tag Box, This will aid future searches.
• When drafting a question, try and lay out the question in a clear and concise way.
• Try and tell the readers what is the situation, what have you tried and what do you want to achieve.
• Don't leave out information more info is better
• For the best/fastest results, Upload a Sample File using the "Upload a File" button at the bottom of the page.
• To share Files/Pictures, you can use the "Upload a File" button.
• Please use language which conveys respect, appreciation and love.
• Consider that the world is operating 24hrs a day. A late post today may well be answered by someone else overnight.
• Start a new post every time you ask a question, even if the theme is similar. The original author may continue asking questions whilst the post is in progress and of course if you are answering questions you may need to ask questions of the initial poster.
• Please post, new posts in the correct forums, not as Emails/Messages to people
• Quickly search the Web and Chandoo.org for help before posting. It is quite possible that your problem has been solved by someone else.
• If you and a reader have been involved in an ongoing conversation and the conversation suddenly stops, recognize that the person may have gone to bed, even though you have just arrived at work. In the worst case a reader may go on holidays and not get back to the question for a few days.
• Check your posts regularly for answers. Login, then Click your User Name at the top of the page. That takes you to a screen where your posts are listed along with the date of the last reply.
• At Chandoo.org we have two forums dealing with FAQ's for common Excel and VBA solutions.

K

Thread 'Site Rules - New Users - Please Read'

Feb 18, 2010

Hi all,

Welcome to the Chandoo.org Forums.

Posting Rules & Etiquette

The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge.

The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in.

Please take a few minutes to read this list of Rules, Procedures and Etiquette's for posting here at the Chandoo.org Forums.

How to get the Best Results at Chandoo.org

• Use Relevant words in the Title and in the tag Box, This will aid future searches...

• keymaster
• Replies: 0
• Forum: Ask an Excel Question

• 

 

[AlanSidman]

Power Query

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Unpivoted Other Columns" = Table.UnpivotOtherColumns(Source, {"No."}, "Attribute", "Value"),
#"Removed Columns" = Table.RemoveColumns(#"Unpivoted Other Columns",{"Attribute"}),
#"Grouped Rows" = Table.Group(#"Removed Columns", {"No."}, {{"Count", each _, type table [#"No."=number, Value=text]}}),
#"Added Custom" = Table.AddColumn(#"Grouped Rows", "Custom", each Table.AddIndexColumn([Count],"Index",1,1)),
#"Removed Other Columns" = Table.SelectColumns(#"Added Custom",{"Custom"}),
#"Expanded Custom" = Table.ExpandTableColumn(#"Removed Other Columns", "Custom", {"No.", "Value", "Index"}, {"No.", "Value", "Index"}),
#"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Expanded Custom", {{"Index", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Expanded Custom", {{"Index", type text}}, "en-US")[Index]), "Index", "Value")
in
#"Pivoted Column"