Challenge #36: Data Cleansing Extract Authors

[Alekh]

My solution

[AJauniskis]

My solution:

Spoiler

[Sajeel_Kershi]

used text to columns to split on "-", filtered out for "PMID" and "FAU". Copied PMID down for each group and then applied crosstab to get result

[rfergus]

Spoiler

[FeedMeData]

Here's my solution

[gurth]

A little kludgey, but seems to work...

[Anastasiia]

Here is my solution

[JonathanAllenby]

Here's my solution to challenge 36!

[Jonathan-Sherman]

Number 36 is done!

Spoiler

[Thableaus]

Challenge #36, done.

Good practice to clean data. 

Spoiler

Cheers,