Joe_Fox
Well-Known Member
Here is a tricky one for you to have a go at:
I've got the following data
I want to do something so that I get the following from the same data:
So basically moving everything in columns C and D into column B whilst keeping it's related column A data.
Does anyone have any idea how? I'm stumped!
I've got the following data
Code:
A B C D
1 JOE 23 24 18
2 KIM 56
3 BOB 19 40
4 LIZ 79 41 42
5 AMY 88 32
I want to do something so that I get the following from the same data:
Code:
A B C D
1 JOE 23
2 JOE 24
3 JOE 18
4 KIM 56
5 BOB 19
6 BOB 40
7 LIZ 79
8 LIZ 41
9 LIZ 42
10 AMY 88
11 AMY 32
So basically moving everything in columns C and D into column B whilst keeping it's related column A data.
Does anyone have any idea how? I'm stumped!