transpose column based on unique values

[sanju2323]

Hi every one,
I need to transpose column into horizontal rows based on unique values as showing in excel. Do you have any code to solve this problem?

[karedog]

Maybe :

Please Login or Register  to view this content.

[banaanas]

This seems to work pretty well. Remeber to change the sheet variables to your liking!

Please Login or Register  to view this content.

[sanju2323]

karedog,
Thanks for the code, but there is a small problem. From "A" to "E" there is a fixed column as shown in the sheet "Require'", I have attached another file as you can see..

[sanju2323]

banaanas,
Your code is also better for use reverse data. Thank you.

[karedog]

If you need the number of columns is fixed to 5 (not dynamic based on actual number of columns existed), then delete the red line and add the blue line code below :

Please Login or Register  to view this content.

Complete code :

Please Login or Register  to view this content.

[sanju2323]

karedog,
It's working very well as I expected.
Thank you so much

[Winon]

@ karedog,

Dear Sir,

Please stop testing my temper! DON'T use Sheet Names. If the Sheet Name changes, your Code means nothing!
Please change your Code to refer to the Sheet Index Number instead.

I REALLY like your Code, well done my Friend!

Kudos to you.

Kind Regards.

[karedog]

@sanju,
You are welcome, thank for marking the thread as solved.

@Winon,
My Lord Winon the Dukes of Bad Temper Castle,
It is my honour to have Thy presence on my posts.
Although the truth is all Thine,
but the peasants like it when the Sheet's names is used instead of Sheet's Index,
since it is easier to adapt to their actual file(s).
Upset not with this my Lord, the glory be all Thou art worth.


Regards

[daboho]

karedog from this case how to make parent and child collection
strkey1 = columns(a) is key 1
strkey2 = columns(b) is key 2
i want have 2 collection
see this picture
karedog1.png

Please Login or Register  to view this content.

[karedog]

Should be :

Please Login or Register  to view this content.

[daboho]

thank your very match karedog
i want ask more again
how to remove not double child 2 key
in my picture row(7) count = 1 ignore it
i want to know COUNT For collections(1) and collection(2) and collection(3)
and how to remove from collection if ignore value like in row(7)
karedog col.png

Please Login or Register  to view this content.

[karedog]

Please Login or Register  to view this content.

If you have more questions, please start a new thread, you are hijacking someone else's thread.
(Forum member sanju2323 (OP) and banaanas will keep get new notifications, while they are already not interested in this topic)