Jun 28 2021 11:08 AM
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
10504924 | 630650 |
10504924 | 630650 |
10529343 | 658142 |
10529343 | 658142 |
10529687 | 1218542 |
10533598 | 941242 |
10550870 | |
10555409 | 694181 |
10555409 | 1056793 |
10555409 | 1056793 |
10585795 | 729299 |
10585838 | 733083 |
10585838 | 848732 |
10590125 | 981913 |
Jun 28 2021 01:58 PM
That's more job for Power Query if you consider such option
- query the range, group by A without aggregation, extract B as list values and split column.