I need to be able to filter massive amounts of data across multiple rows (of varied column length) to remove all repetition in the data set.
Example is attached that has a set of data becoming a row of unique data.
Anyone have a smart and simple way to do this? By hand would we incredibly time intensive and innacurate.
Data Set
<colgroup><col span="5"></colgroup><tbody>
</tbody>
Any good thoughts?
Thanks!
Example is attached that has a set of data becoming a row of unique data.
Anyone have a smart and simple way to do this? By hand would we incredibly time intensive and innacurate.
Data Set
ACD: Mike - AP5 | OJ: Ranger - PP1 | NB: Rome - 425 | ||
NPS: Avery - I3 | ACD: Mike - AP5 | |||
NPS: Avery - I3 | ACD: Mike - AP5 | |||
NPS: Avery - I3 | OJ: Ranger - PP1 | UJ: XKCD - 87 | ACD: Mike - AP5 | |
NPS: Avery - I3 | OJ: Ranger - PP1 | UJ: XKCD - 87 | ACD: Mike - AP5 | |
OJ: Ranger - PP1 | UJ: XKCD - 87 | NB: Rome - 425 | ||
OJ: Ranger - PP1 | UJ: XKCD - 87 | ACD: Mike - AP5 | NB: Rome - 425 | |
Ideally becomes | ||||
ACD: Mike - AP5 | OJ: Ranger - PP1 | NB: Rome - 425 | NPS: Avery - I3 | UJ: XKCD - 87 |
<colgroup><col span="5"></colgroup><tbody>
</tbody>
Any good thoughts?
Thanks!