Dataset issue

New Contributor

I have an excel sheet that i have 2 columns for, the problem i am having is trying to look up the data for a particular number, i have tried a pivot table but it does not give me the correct data from the cells, here is an example of the data i am trying to mine. i would eliminate the dups but that would be a manual process, i need the data from the 2nd column to show up using some type of lookup in to 3 columns, for example: Column A = 10504924, Column B = 630650, Column C = 630650 and so on, as you can see the data below can have different column B and C data based on Column A. Not all the column A's have a 2nd number for column C to to fill so a "0" value is fine

 

10504924630650
10504924630650
10529343658142
10529343658142
105296871218542
10533598941242
10550870 
10555409694181
105554091056793
105554091056793
10585795729299
10585838733083
10585838848732
10590125981913
1 Reply

@prometheis 

That's more job for Power Query if you consider such option

image.png

- query the range, group by A without aggregation, extract B as list values and split column.