Horizental to Vertical Data arrangment

[vinaynaran]

Hi all,
Please see attached XLS file. In "Data" sheet I have raw data and i want to display like "OUTPUT" sheet.

Is there any shot cuts to do?

Please advice.

Vinay

[martindwilson]

ok what ive done is extract a list of unique parts into column d(see formula in d)
then copied /paste special values into column E, sorted column e then removed blanks(highlight blanks right click delete ,move cells up)
then used index/match in table

[vinaynaran]

Hi Martin,

You are genius.
It’s saved lots of time and working perfect.

A big thank to you.

REgards
Vinay