Hello, I am trying to convert the following table:
<tbody>
</tbody>
into this format:
<tbody>
</tbody>
Essentially, I need for Excel to recognize instances in which a unique identifier (ID here) is represented on multiple rows, and then convert the data associated with these instances into a Column format.
I have KUTools and have a basic understanding of VBA. Any help is much appreciated!
ID Number | Purchase Amount | Purchase Type |
23 | $86 | Product X |
24 | $56 | Product Y |
25 | $66 | Product X |
23 | $88 | Product Y |
23 | $90 | Product Z |
<tbody>
</tbody>
into this format:
ID Number | Purchase Amount 1 | Purchase Type 1 | Purchase Amount 2 | Purchase Type 2 | Purchase Amount 3 | Purchase Type 3 |
23 | $86 | Product X | $88 | Product Y | $90 | Product Z |
24 | $56 | Product Y | ||||
25 | $66 | Product X |
<tbody>
</tbody>
Essentially, I need for Excel to recognize instances in which a unique identifier (ID here) is represented on multiple rows, and then convert the data associated with these instances into a Column format.
I have KUTools and have a basic understanding of VBA. Any help is much appreciated!