RachaelH
New member
- Joined
- Feb 11, 2019
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
Hi, I am looking for assistance on how to create a normalised table from denormalised data using Power Query.
My source data is in two columns and looks like this
I want it to look like this
My source data is in two columns and looks like this
Column 1 | Column 2 |
Division Description | Group Description |
Mathematical Sciences | Pure Mathematics |
Mathematical Sciences | Applied Mathematics |
Mathematical Sciences | Numerical and Computational Mathematics |
Mathematical Sciences | Statistics |
Mathematical Sciences | Mathematical Physics |
Mathematical Sciences | Other Mathematical Sciences |
Physical Sciences | Astronomical and Space Sciences |
Physical Sciences | Atomic, Molecular, Nuclear, Particle and Plasma Physics |
Physical Sciences | Classical Physics |
Physical Sciences | Condensed Matter Physics |
Physical Sciences | Optical Physics |
Physical Sciences | Quantum Physics |
Physical Sciences | Other Physical Sciences |
Chemical Sciences | Analytical Chemistry |
Chemical Sciences | Inorganic Chemistry |
Chemical Sciences | Macromolecular and Materials Chemistry |
Chemical Sciences | Medicinal and Biomolecular Chemistry |
Chemical Sciences | Organic Chemistry |
Chemical Sciences | Physical Chemistry (incl. Structural) |
Chemical Sciences | Theoretical and Computational Chemistry |
Chemical Sciences | Other Chemical Sciences |
I want it to look like this
Mathematical Sciences | Physical Sciences | Chemical Sciences | |||||||||||||||||||||
|
|
| |||||||||||||||||||||