Iterative macro - alternative solution

[Rico_Widmayer]

Hi community 😊

I am very curious if somebody knows a better solution to my current problem:

May table looks like this: First column contains an ID which occurs multiple times and second column contains the values.

Record ID	Value
1	100
1	122
1	99
1	134
2	90
2	85
2	35
2	22
3	87
3	345
3	32
3	45
4	21
4	54
4	33
4	45
5	99
5	190
5	345
5	34
…	…

What I like to have is a different structure of this table. I want to have all IDs next to each other (hope thats the correct term). So that it looks like this. There is probably a transform tool for that, but I just do not get it ? 

I implemented a solution via Interative macro, but as the RecordIDs are more than 4,000 the performance is terrible. 

I would highly appreciate any kind of help. I am probably just over-complicating things...

Thank you!!!

Record ID	Value	Record ID2	Value2	Record ID3	Value3	Record ID4	Value4	Record ID5	Value5
1	100	2	90	3	87	4	21	5	99
1	122	2	85	3	345	4	54	5	190
1	99	2	35	3	32	4	33	5	345
1	134	2	22	3	45	4	45	5	34

[Luke_C]

Hi @Rico_Widmayer 

The make columns tool can get you this presentation, it looks like it can only support 1000 record IDs, though. 

[DataNath]

Would imagine this is crazy overboard but managed to put something together that tackles this:

[Felipe_Ribeir0 · Accepted solution]

Hi @Rico_Widmayer 

Another way of doing this:

[Rico_Widmayer]

Thank a lot to all! All solutions worked for my purpose 🙂