fireman_max
New Member
- Joined
- Apr 24, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hi. I am about to break my computer. I have no idea how to make this work. Hoping this can be fixed in a way a newb can understand (without coding)
I have to do this work all the time. In column 1 I get the station name.
In col 2,3, 4, 5, 6 (sometimes all the way out to 10) I get individual crew members. But different station names have different numbers of crew
What I have to have is two columns. The first with the station name, the second with the crew member, So the above turns into this:
I do this manually right now by counting how many columns out the names go, inserting rows, copying the station name down as many spots as I need, and dragging all the names in one-by-one. I can't take it anymore. Can't the computer do this for me? Is there a way to do it if I'm just a regular guy and not some spreadsheet genius?
I have to do this work all the time. In column 1 I get the station name.
In col 2,3, 4, 5, 6 (sometimes all the way out to 10) I get individual crew members. But different station names have different numbers of crew
Goose Hill Station #1 | Sam P. | Jeff | Ed | Mark S. | |
Pemrose | Jonas | Mark F. | Frank | ||
Tiger House | Crandell | Emmet | |||
Fitch Road | Dillion | AJ | Sam B. | ||
Jackson (Mitch House) | Crell | ||||
Jefferson #3 | Mark O. |
What I have to have is two columns. The first with the station name, the second with the crew member, So the above turns into this:
Goose Hill Station #1 | Sam P. |
Goose Hill Station #1 | Jeff |
Goose Hill Station #1 | Ed |
Goose Hill Station #1 | Mark S. |
Pemrose | Jonas |
Pemrose | Mark F. |
Pemrose | Frank |
Tiger House | Crandell |
Tiger House | Emmet |
Fitch Road | Dillon |
Fitch Road | AJ |
Fitch Road | Sam B. |
Jackson (Mitch House) | Crell |
Jefferson #3 | Mark O. |
I do this manually right now by counting how many columns out the names go, inserting rows, copying the station name down as many spots as I need, and dragging all the names in one-by-one. I can't take it anymore. Can't the computer do this for me? Is there a way to do it if I'm just a regular guy and not some spreadsheet genius?