C/P part of a column into a row

I have data that looks like this:

ADD ADD 5
ADD EMPTY 2
AGAIN AGAIN 26
AGAIN EMPTY 17
AGAIN BACK 1
ALL ALL 24
ALL EMPTY 19
ALRIGHT FINE 1
ALRIGHT OKAY 2
ALRIGHT ALRIGHT 3
ALRIGHT EMPTY 3
ALRIGHT RIGHT 1


I want it to look like this:

ADD ADD EMPTY
5 2
AGAIN AGAIN EMPTY BACK
26 17 1
ALL ALL EMPTY
24 19
ALRIGHT FINE OKAY ALRIGHT EMPTY RIGHT
1 2 3 3 1

i.e all the entries from column B that have the same thing in column A should be on a row together, with the number from column C under them.
If that's a bit hard then it would be OK if it looked like this:
ADD ADD 5
ADD EMPTY 2

AGAIN AGAIN 26
AGAIN EMPTY 17
AGAIN BACK 1

ALL ALL 24
ALL EMPTY 19

ALRIGHT FINE 1
ALRIGHT OKAY 2
ALRIGHT ALRIGHT 3
ALRIGHT EMPTY 3
ALRIGHT RIGHT 1

Any ideas?
test.xlsx

Hi there,
You wrote: '...with the number from column C under them.'.
But in your attachement, there are not numbers in col C.

pls check that.

Regards

M

Hiya, Thanks for responding.

Hmm, I don't know. The numbers are there on my computer. I'll re-upload it, maybe they will appear.

I will put the sample in 2 sheets, maybe that would be easier to work with.

Hi evene,

that was great exercise for me... so thank you...

See attached test file.

I had to create unique value list from col A (and it is dynamic), so when your source reaches more tha 12 unique values, drag down the formula in col E.

It is a little bit complicated with the extract - you have to copy the blocks down (not dragging) and of course, drag to the right if necessary.

So pls do some tests and let me know if it is ok for You...

test (1).xlsx

Hope it helps

Regards

M

Hi Miroslav,

Thank you for working on my problem. Your solution does work, but unfortunately my computer is a bit old and slow and Excel just freezes when I try to use those formulas. I am thinking now I will export the data as csv to another program to arrange it the way I want. But thank you for your help.

Evene

Hi evene,

You are welcome!

(maybe try som VBA solution...)

Regards

M

(Do not forget to close this thread, if provided solution was sufficient. And if you like the solution, add reputation in bottom left corner)