Hi all,
I'm looking for an easy way to link the below title and artist with each other. I tried text to column but the problem is that I'm getting duplicate rows (second table below)... is there another multi-row solution for this?
Title and artist linked through color:
year | category | Title | Artist |
1978 | Nederlandse zang | Moet niet zeuren,Het beste is mij niet goed genoeg voor jou | Tol Hansse,Peter Koelewijn |
1978 | Pop Internationaal | City to city,My aim is true | Gerry Rafferty,Elvis Costello |
When doing text to column, split to rows:
Field1 | Field2 | Field3 | Field4 |
1978 | Nederlandse zang | Moet niet zeuren | Tol Hansse |
1978 | Nederlandse zang | Het beste is mij niet goed genoeg voor jou | Tol Hansse |
1978 | Nederlandse zang | Moet niet zeuren | Peter Koelewijn |
1978 | Nederlandse zang | Het beste is mij niet goed genoeg voor jou | Peter Koelewijn |
Solved! Go to Solution.
Start with @echuong1 solution.
In the first text to columns tool, split the Title. You will then have Title 1 and Title 2.
In the second Text to Columns tool, do the same for the Artist column, resulting in Artist 1 and Artist 2.
Using 2 select tools, first select year, category, Title1 and Artist1. Rename the last columns as Title and Artist.
Then in the other select tool, pick year, category, Title2 and Artist2. Rename those as well to Title and Artist.
Union the two streams together and you should have the desired results.
Great, thank you!!