I have two columns of data I need to integrate and I was running into some trouble
This is my example sheet:
and I need the output to be:
This is my example sheet:
| Example Sheet.xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | Category | Description | ||
| 2 | ||||
| 3 | Basketball | AAAA | ||
| 4 | Basketball | BBBB | ||
| 5 | Soccer | CCCC | ||
| 6 | Soccer | DDDD | ||
| 7 | Soccer | EEEE | ||
| 8 | Tennis | FFFF | ||
| 9 | Tennis | GGGG | ||
Sheet1 | ||||
and I need the output to be:
| Example Sheet.xlsm | |||
|---|---|---|---|
| A | |||
| 1 | Category_Description | ||
| 2 | |||
| 3 | Basketball | ||
| 4 | AAAA | ||
| 5 | BBBB | ||
| 6 | Soccer | ||
| 7 | CCCC | ||
| 8 | DDDD | ||
| 9 | EEEE | ||
| 10 | Tennis | ||
| 11 | FFFF | ||
| 12 | GGGG | ||
Sheet4 | |||
