Hi Guys,
I have a small matching problem.
I have three columns "A" as well as "B". and its counter (number of the row assigned to the IDs.).
In the column "A" I have unique IDs, in the column "B" the same IDs which however can appear more often 17 times or not it all (Please see the attachment).
The counter and Column A:
Column
AAA
BBB
CCC
NNN
The counter and Column B:
Counter, Column B
1. AAA
2. AAA
3. BBB
4. NNN
5. AAA
I wanto to create odput where between the column "A" and the counter of the column "B" is a table with number of rows (counters) (size #number of vlaues in column A times 17) in which IDs in column A appear in Column B.
Column A, 1, 2....17
AAA, 1, 2, 5, 0,....
BBB, 3,0,....
CCC,0...
NNN,4,0....
If you could help me to develop the code I invite you for Wiener Schnitzel in Vienna and beer.
Reply With Quote