Gather similar data from multiple columns

[YasserKhalil]

Hello everyone
I have in column A many similar items and each item may have several values in adjacent columns
I need to gather all related values for specific items

For example: I have "A" value in A2 & A6 & A9 and there are many values in adjacent columns as follows :
as for A2 : there are B2 / C2 / E2 have the values 75 / 33 / 65
as for A6 : there are B6 / E6 have the values 47 /10
as for A9 : there are B9 / C9 have the values 98 /63

In results I need to gather these values in adjacent columns as follows
A 75 33 56 47 10 89 63
Hope it is clear

 

[Marc L]

Hi !

As shown several times within your own threads from different forums,
just use a Dictionary object to store keys (Header) and their items (Tot)
delimited by a tabulation and at end write back to a column and
convert to cells by TextToColumns method for example …

Other way, like a beginner, use basic Excel function MATCH and
VBA End property to put data in right place …
​