Hi All,
I've been banging my head against this for the last hour or so, and I just can't figure it out, so I'm hoping that someone can help.
I have a set of data that is in this format:
| Job 1 category | Job 1 description | Job 2 category | Job 2 description | Job 3 category | Job 3 description |
| category 1 | Job 1 cat 1 description 1 | category 1 | Job 2 cat 1 description 1 | category 1 | Job 3 cat 1 description 1 |
| category 1 | Job 1 cat 1 description 2 | category 1 | Job 2 cat 1 description 2 | category 1 | Job 3 cat 1 description 2 |
| category 1 | Job 1 cat 1 description 3 | category 2 | Job 2 cat 2 description 1 | category 1 | Job 3 cat 1 description 3 |
| category 2 | Job 1 cat 2 description 1 | category 2 | Job 2 cat 2 description 2 | category 1 | Job 3 cat 1 description 4 |
| category 2 | Job 1 cat 2 description 2 | category 3 | Job 2 cat 3 description 1 | category 2 | Job 3 cat 2 description 1 |
| category 2 | Job 1 cat 2 description 3 | category 3 | Job 2 cat 3 description 2 | category 2 | Job 3 cat 2 description 2 |
| category 3 | Job 1 cat 3 description 1 | category 3 | Job 2 cat 3 description 3 | category 2 | Job 3 cat 2 description 3 |
| category 3 | Job 1 cat 3 description 2 | | | category 3 | Job 3 cat 3 description 1 |
| category 3 | Job 1 cat 3 description 3 | | | category 3 | Job 3 cat 3 description 2 |
but I need it to look like this:
| Category | Job 1 | Job 2 | Job 3 |
| category 1 | Job 1 cat 1 description 1 | Job 2 cat 1 description 1 | Job 3 cat 1 description 1 |
| category 1 | Job 1 cat 1 description 2 | Job 2 cat 1 description 2 | Job 3 cat 1 description 2 |
| category 1 | Job 1 cat 1 description 3 | | Job 3 cat 1 description 3 |
| category 1 | | | Job 3 cat 1 description 4 |
| category 2 | Job 1 cat 2 description 1 | Job 2 cat 2 description 1 | Job 3 cat 2 description 1 |
| category 2 | Job 1 cat 2 description 2 | Job 2 cat 2 description 2 | Job 3 cat 2 description 2 |
| category 2 | Job 1 cat 2 description 3 | | Job 3 cat 2 description 3 |
| category 3 | Job 1 cat 3 description 1 | Job 2 cat 3 description 1 | |
| category 3 | Job 1 cat 3 description 2 | Job 2 cat 3 description 2 | Job 3 cat 3 description 1 |
| category 3 | Job 1 cat 3 description 3 | Job 2 cat 3 description 3 | Job 3 cat 3 description 2 |
It's not a straightforward as just removing the category columns, because some have more descriptions for the same category as others. I have a large number of jobs and their associated descriptions so I didn't really want to do this manually - although it's taken me so long I might have been better off just doing a copy & paste job now, but I don't like to be beaten.
I'm hoping it's something simple and it's just me not spotting the obvious solution.
Any help would be appreciated.
Thanks
PuffinPanic
