Audra Breedlove
asked on
Transpose Date in multiple columns to one column
Hello, I need a macro to transposed dates in five columns into one column.
Columns A-H is the raw data
Column J-M are the desired results
If possible, I need the results to only display dates because every record doesn't have dates across all five columns so sum will be blank
The key fields are A,B,C and they need to be displayed on the results, in Order of Pers.no. then ascending in date order
Transpose-Dates-in-many-columns-int.xlsx
Columns A-H is the raw data
Column J-M are the desired results
If possible, I need the results to only display dates because every record doesn't have dates across all five columns so sum will be blank
The key fields are A,B,C and they need to be displayed on the results, in Order of Pers.no. then ascending in date order
Transpose-Dates-in-many-columns-int.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome Audra! Glad it worked as desired.
Thanks for the testimonial!
Thanks for the testimonial!
ASKER