Forum Discussion
How to fill blanks with values from same table
Hi everyone,
I'm trying to fill blank values in one table, based on values from that same table. I'm working with usernames and ID's. Basically, perform something similar to VLOOKUP from Excel.
I hope this SS helps me make my point more clear.
From the SS, the values in yellow are those who I'm looking for.
I've already tried LOOKUPVALUE, but since I have duplicated usernames, my formula is not working.
Thank you all for your help.
Regards.
Hi rpablo
It is possible to achieve the desired result by using PQ.
The following steps should be performed after loading the table:
1. Sort it by your "local user name"2. Do the same with your "contactsID" the order of sorting : Descending
3. Use the "Fill down"
Result:
If your value is Text and you have BLANKS cells before "fill down" add a step of replace value from blank to null
A sample file can be downloaded from the following link
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi rpablo
It is possible to achieve the desired result by using PQ.
The following steps should be performed after loading the table:
1. Sort it by your "local user name"2. Do the same with your "contactsID" the order of sorting : Descending
3. Use the "Fill down"
Result:
If your value is Text and you have BLANKS cells before "fill down" add a step of replace value from blank to null
A sample file can be downloaded from the following link
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
