79466361

Date: 2025-02-25 11:19:00
Score: 2.5
Natty:
Report link

Let say your column is A with all values with type(2). Insert a new column besides it say B. Manually type he value of first cell of A into B. Select all rows of column B and then go to Data>Flash fill. You will get all values in Column B with Type(1). delete Coulumn A.

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Single line (0.5):
  • Low reputation (1):
Posted by: Kashif Mansoorie