79777874

Date: 2025-09-29 08:20:13
Score: 1
Natty:
Report link

Best I can think of is making a prompt and sending it alongside the columns to an AI: Example

Prompt:

I have a two-column table where the data is mixed up:

The left column should contain Job Titles.

The right column should contain Company Names.
But in many rows, the values are swapped (the job title is in the company column and the company is in the job title column).

Your task:

For each row, decide which value is the Job Title and which is the Company Name.

Output a clean table with two columns:

Column 1 = Job Title

Column 2 = Company Name

If you are uncertain, make your best guess based on common job title words (e.g., “Engineer”, “Manager”, “Developer”, “Director”, “Intern”, “Designer”, “Analyst”, “Officer”, etc.) versus typical company names (ending with “Inc”, “Ltd”, “LLC”, “Technologies”, “Solutions”, etc.).

Keep the table format so I can paste it back into Google Sheets.

Here is the data that needs to be corrected:
COL A:
...
COL B:
...
Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Soner Kochan