Copy Value when other value same

[LucTP]

Hi All,

Plz suggest way to copy value from a row, when  value colume Name same, below example data

Name	Value
A
B	3
A	1
C
B
A	1
B	3
C	7

result 

Name	Value
A	1
B	3
A	1
C	7
B	3
A	1
B	3
C	7

Thanks & Regards,

LucTP

[PhilipTreacy · Accepted solution]

Hi @LucTP 

Download PBIX file with the example below

Quick way to do it is first of all add an Index column, then sort by the name column and by the Value column (Descending) to give this

Then in the value column Fill Down

Then sort by the Index column (Descending) - then delete the Index column as it's no longer needed.

Regards

Phil