Transpose a few rows of a very long column

Hi, thanks in advance for any help

I have a very large table and want to transpose out small portions of it for use elsewhere. the data looks like this (but goes from 1 to ~17000 datasets), i.e. for dataset1, group 1: six scored 1 and one scored 5, and dataset1, group 2: two scored 1, three scored 2, one scored 3 and one scored 4

(im attaching an excel sheet with the same info so its easier to understand)

dataset1 group1 group2
Score 1: 6 2
Score 2: 0 3
Score 3: 0 1
Score 4: 0 1
Score 5: 1 0
dataset2
Score 1: 1 0
Score 2: 4 3
Score 3: 1 4
Score 4: 1 0
dataset3
Score 1: 7 1
Score 2: 0 6

etc...

i would like to convert it to this:

group1 group2
dataset1 6 0 0 0 1 dataset1 2 3 1 1 0
dataset2 1 4 1 1 dataset2 0 3 4 0
dataset3 7 0 dataset3 1 6

etc...

it doesnt need to say 'score 1, score 2' across the top of the table, but if theres five columns in the 'group 1' there needs to be five for group 2. note that theres always a total of 14 for each dataset, if that matters.

thanks lots! this is driving me up the wall

--mark

Hi mchapman47,

see the attached file where I have used Transpose function to obtain the desired result and then you can always filter and copy / use the data. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

your are welcome... mchapman47,

cheers

if this solves your purpose, request to mark this thread as solved.

Regards,
DILIPandey

<click on below 'star' if this helps>