An alternative solution based upon Power Query/Get & Transform found on the Data Tab of the Ribbon
Excel 2016 (Windows) 32 bit
|
A |
B |
C |
1 |
Column1.1 |
Column1.2 |
Column1.3 |
2 |
21 |
3 |
1 |
3 |
12 |
18 |
2 |
4 |
5 |
16 |
0 |
5 |
20 |
3 |
1 |
6 |
22 |
6 |
0 |
7 |
9 |
17 |
0 |
Review PQ
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps
M-code basics:
- "let" is the start of a query
- "in" is the closing of a query
- each transformation step sits in between those 2 lines
- each step line is ended by a comma, except the last one
- "Source" is always the first step (Source Data)
- After "in" you have the last step referenced
Bookmarks