I have the sheet Keywords with columns A-G. Column A is Niche, Column B is Primary Keywords, Column C is Secondary Keyword 1, Column D is Second Keyword 2, Column E is Second Keyword 3, Column F is Second Keyword 4, Column G is Second Keyword 5.

I think you're after something like this possibly? If not maybe post a picture with what the desired end result is, because the verbal description is a little hard. You also may need a more unique identifier such as a company name or ID if this is what you're after. Additionally check out this channel if you want a good resource for learning. Learn Google/Excel Sheets

Remove this answer if not helpful, or should be a comment.