paste special (transpose) based on common cell contents

[Pie Captain]

Hi All,
First of all I'd like to apologise if this has been answered elsewhere, i have searched, but haven't been able to find a solution. Some might come close, but I have no VBA experience (yet!), so I'm not sure how to customise previous answers to suit.

Anyway, here goes...

I have a spreadsheet with the following columns…

Sequence PR Data1 Data2 Data3

I need to be able to do a copy / paste special:transpose based in the information in the Sequence column
So that all Rows with a matching sequence number are combined, note that for constant values of sequence, PR, Data1 and Data2 are constant, it's just the Data3 column that needs to be transposed and then the superflous rows deleted.

Eg.

Sequence PR Data1 Data2 Data3
1 33 Jam bread potato
1 33 Jam bread orange
1 33 Jam bread tomato
2 44 Banana crisp cabbage
2 44 Banana crisp cheese

Should be..

Sequence PR Data1 Data2 Data3
1 33 Jam bread potato orange tomato
2 44 Banana crisp cabbage cheese

Sorry I can't include the actual spreadsheet, but the data is sensitive. Hopefully my example makes sense, but please let me know if you need more info.

Many thanks in advance!

Paul

 

[Gerald Higgins]

This is do-able in a roundabout way with helper columns.
Is that an option for you ?
If it IS, can you confirm please that all these data elements are in separate columns ?