Forum Discussion
Duplicate Data
I have a spreadsheet with 4,000 lines. When I am extracting the data from the original source, its in a 1 to 1 relationship. How do I get it from a 1 to 1 relationship to 1 to many relationship in ex...
Hi Ryan,
You may add helper column D with formula
=IF(COUNTIF($A$1:A1,A1)>1,"",A1)
drag it down till end of the range.
Filter column D and select only blank cells. On filtered range select column A except header row and press Delete. Remove the filter and helper column if not needed.
Attached.
Great, this is exactly what I was looking for. Is it possible to do this is power BI before I load the formula into excel?
Ryan, do you mean to do that transformation with Power Query into separate table?
If you publish that workbook on Power BI services you may do what you want with it at any time.
I ran into some issues with the data. What changes would I need to make to the formula if items owned is not consistent among owners? I have corrected my sample data and uploaded it again.
