Need help organising data

Hello all,

Not sure if this is in the correct part of the forum but here goes.

I am in dire need of some expert assistance as my limited knowledge of Excel has my completely stumped.

I have attached a small spreadsheet (just a snippet of the amount of data i actually have to process) that demonstrates the current format and required format.

There are approx 175k rows of data although this will be smaller when the job is actually run as I need to remove some erroneous data.

If anyone can help me in trying to organize my data I would be hugely grateful.

many thanks

Arvon

Hi Richard

many thanks for your response. I have tried to add the full dataset but the file is too big.

I have attached the first 100 rows of data to get a better feel.

each skill category needs to represent a column header, some of the id's will have more than others and some id's will have more data than others.

I hope this helps.

Hi

is the data enough to work on?