- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

"Flatten" a Table with Power Query
Hello! I am retrieving data from a database via Power Query and it looks like below.
From Power Query
I want to group the data by "sid" and and transpose the name column to headers such that it looks like below.
Required Format
Any direction would be well appreciated! I am using Power Query.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Des75 , here is an example of what you can do, if I understood well your problem:
Steps:
1. Select "Transform" ribbon item
2. Select the column in which you have your future headers (for you it will be "name")
3. Press "Pivot column" button
4. In the settings, select the column in which you have the values (for you it will be "value")
5. In the advanced settings, select "Do not agregate" option
6. You're done!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi @Des75 , here is an example of what you can do, if I understood well your problem:
Steps:
1. Select "Transform" ribbon item
2. Select the column in which you have your future headers (for you it will be "name")
3. Press "Pivot column" button
4. In the settings, select the column in which you have the values (for you it will be "value")
5. In the advanced settings, select "Do not agregate" option
6. You're done!
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Perfect!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-01-2024 06:44 PM | |||
Anonymous
| 03-21-2024 08:15 AM | ||
04-24-2024 03:16 AM | |||
03-06-2024 10:58 AM | |||
06-17-2024 07:48 AM |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |