Reply
Topic Options
- 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

Split column
11-13-2020
06:36 AM
Hello all,
I would like to split some data as the example below.
From this:
column 1 | column 2 | column 3 |
x | a | 12 |
x-1 | a | 34 |
x-2 | a | 3 |
x | b | 6 |
x-1 | b | 5 |
x-2 | b | 19 |
To this:
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 |
x | a | 12 | b | 6 |
x-1 | a | 34 | b | 5 |
x-2 | a | 3 | b | 19 |
I believe that must be an easy way of doing that...
Thank you i n advance.
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2020
06:49 AM

@clovisantonio , refer if this blog can help
https://www.thebiccountant.com/2015/08/12/how-to-pivot-multiple-measurescolumns-in-power-query/
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2020
07:35 AM

Hello amitchandak, thank you very much.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-13-2020
06:49 AM

@clovisantonio , refer if this blog can help
https://www.thebiccountant.com/2015/08/12/how-to-pivot-multiple-measurescolumns-in-power-query/

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
01-19-2024 01:01 PM | |||
06-05-2024 03:34 AM | |||
05-26-2024 07:18 PM | |||
08-21-2024 12:59 AM | |||
06-09-2024 11:42 AM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
141 | |
112 | |
83 | |
63 | |
47 |