Rearrange Data

**snowmonkey** · 09-02-2009, 04:38 AM

Hi everyone. I expect this query has been answered here before, but I am not sure of the right terminology to use so I haven't been able to find a solution via the search. My problem is this. I have a two column data base:

Property, Imagepath
A, domain.com/imageA1.jpg
A, domain.com/imageA2.jpg
A, domain.com/imageA3.jpg
B, domain.com/imageB1.jpg
B, domain.com/imageB2.jpg
B, domain.com/imageB3.jpg

What I want is to group it by property, so I get

Property, Image1, Image2, Image3
A, domain.com/imageA1.jpg, domain.com/imageA2.jpg, domain.com/imageA3.jpg
B, domain.com/imageB1.jpg, domain.com/imageB2.jpg, domain.com/imageB3.jpg

Is this possible in Excel?

Thanks in advance.

**DonkeyOte** · 09-02-2009, 04:55 AM

Yes but...

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

**snowmonkey** · 09-02-2009, 05:34 AM

OK, sample file attached.

The CURRENT worksheet is how the data is currently arranged, the GOAL worksheet is how I'd like it to be arranged.

Thanks

sample.xls

**DonkeyOte** · 09-02-2009, 05:37 AM

Are you looking to do this transposition with formulae or VBA ?

**snowmonkey** · 09-02-2009, 05:46 AM

I am guessing with a formula, because my VB knowledge is, well, Very Basic

However, never say never, I can run macros so I can give it a go!

**DonkeyOte** · 09-02-2009, 05:51 AM

Here is a formula based approach based on your sample file which is set up so as to avoid need for Arrays.

EDIT: Attachment removed in lieu of replacement below...