• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Serialize a set of data


New Member
Hi All!

How do you recommend to serialize a large set of data? I have raw data where each row represents a specific account number. Within each account number there can be multiple activity codes associated with that account number. How do I use vlookup, indirect, match, etc to serialize this data to look at activity 1, activity 2, activity 3, in columns?
Account numbers

Activity codes (codes are numeric and text)