Excel Power Query Group by

0 votes

I have a table with two columns and some rows, and I want to create new columns for each individual row and different values.

I'm new to Power Query, but I already know the solution in VBA, so I need it there.

enter image description here

Jan 12 in Others by Kithuzzz
• 28,900 points
32 views

1 answer to this question.

0 votes

Try this

let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Grouped Rows" = Table.Group(Source, {"letters"}, {{"data", each Table.AddIndexColumn(_, "Index", 0, 1, Int64.Type), type table }}),
#"Expanded data" = Table.ExpandTableColumn(#"Grouped Rows", "data", {"group a", "Index"}, {"group a", "Index"}),
#"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Expanded data", {{"Index", type text}}, "en-US"), List.Distinct(Table.TransformColumnTypes(#"Expanded data", {{"Index", type text}}, "en-US")[Index]), "Index", "group a", List.Sum)
in  #"Pivoted Column"

enter image description here

answered Jan 12 by narikkadan
• 53,520 points

Related Questions In Others

0 votes
1 answer

SQL Server: Difference between PARTITION BY and GROUP BY

We can take a simple example. Consider a ...READ MORE

answered Jun 21, 2022 in Others by nisha
• 2,190 points
348 views
0 votes
0 answers

SQL Group By with an Order By

I have a table of tags and ...READ MORE

Jun 22, 2022 in Others by nisha
• 2,190 points
73 views
0 votes
1 answer

Excel web query to login into a website

To be recognized by the web server ...READ MORE

answered Sep 21, 2022 in Others by narikkadan
• 53,520 points
464 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
3,016 views
0 votes
1 answer

Power Query : http POST request with form data

Try using Uri.BuildQueryString and Json.Document. let ...READ MORE

answered Dec 12, 2018 in Power BI by Upasana
• 8,620 points
7,443 views
0 votes
1 answer

Power Query : Adding Columns and Multiple files

The following call, FirstRowAsHeader = Table.PromoteHeaders(TableWithoutHeader) shall replace the ...READ MORE

answered Feb 14, 2019 in Power BI by Upasana
• 8,620 points
1,099 views
0 votes
1 answer

Power Query : making HTTP POST request with form data

Try Using Uri.BuildQueryString and Json.Document let ...READ MORE

answered Feb 14, 2019 in Power BI by Upasana
• 8,620 points
4,811 views
0 votes
1 answer

Excel Power Query import (same file but with different month name)

Use the name manager function in Excel ...READ MORE

answered Dec 13, 2022 in Others by narikkadan
• 53,520 points
75 views
0 votes
1 answer

Stop power query from loading to excel sheet

You can just delete the worksheets created ...READ MORE

answered Dec 17, 2022 in Others by narikkadan
• 53,520 points
69 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP