Inconsistent Values in Cells I’m working with a dataset where multiple values in a cell are tagged under categories like Location, Host, Guest, and Bucket, and separated by line breaks. I need to split these into separate columns based on the tags, but the values are inconsistent, so separating by line break creates many unwanted […]

I need help formatting my data as shown in the image below. These are only 3 columns, I have so many of these. How can I format this.