Hey all! The attached image is a piece of the data set, there are 511 rows. I would like to remove the duplicates in column C, but before doing that I have to extract the data from column "E" and turn that into three separate columns (F, G, H).
For instance C1:C3 are all 17. A1:A3, B1:B3, D1:D3 are all the same values that correspond to C1:C3. However, E1:E3 has three distinct values that correlate to C1:C3 (52015, 54013, and 55014). I would like to add three columns call them First Match, Second Match, Third Match. These columns would list each of these three numbers separately and line up with the row where column C1 = 17. Can this be done in Power Query?
Any help would be much appreciated. Sorry if my post is confusing, please feel free to ask questions to clarify. Thanks in advance!
For instance C1:C3 are all 17. A1:A3, B1:B3, D1:D3 are all the same values that correspond to C1:C3. However, E1:E3 has three distinct values that correlate to C1:C3 (52015, 54013, and 55014). I would like to add three columns call them First Match, Second Match, Third Match. These columns would list each of these three numbers separately and line up with the row where column C1 = 17. Can this be done in Power Query?
Any help would be much appreciated. Sorry if my post is confusing, please feel free to ask questions to clarify. Thanks in advance!