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?
A
Account numbers
B
Activity codes (codes are numeric and text)
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?
A
Account numbers
B
Activity codes (codes are numeric and text)