Clarification on Categorizing the Same ID in Rows with Other Columns
Hi,
I have a dataset where the same ID appears in multiple rows, each with 1 to 3 categories. The columns range from costA to costZ, and I need to consolidate them into a single "Cost" column. My goal is to group by Category 1 according to specific criteria (1 if Category 1 < 2000, 2 if Category 1 = 2000 - 4000, 3 if Category 1 = 4000 - 6000, 4 if Category 1 = 6000 - 10000, 5 if Category 1 > 10000...