Changing some rows to columns

[watsonk1]

Hi Everyone,

FYI, I do not think this is just a simple transpose question.

I have data in the form of:

Item Attribute
Item 1 XXX
Item 1 YYY
Item 1 ZZZ
Item 2 AAA
Item 2 BBB

etc.

I want to reformat my table so that it's like:

Item Attribute 1 Attribute 2 Attribute 3
Item 1 XXX YYY ZZZ
Item 2 AAA BBB

Each item has a variable number of Attributes (between 1 and about 20 of them), so I am looking at having that many columns, which would be fine. I tried to do this with a pivot table but it doesn't seem possible.

Any ideas? Thank you all!!

 

[justmeok]

justmeok,

Be back in a little while with an updated macro.

The best just got better!! Thank you so very much hiker95 you're a LEGEND

 

[hiker95]

justmeok,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.