Hello Everyone!
I receive a weekly excel file with more than 500 rows with multiple entries for a particular pt ID on specific date with data for right, left and both eyes; I need to re-structure it from a column orientation to a row orientation. I thought that using a v lookup will help me to accomplish, but it is more complicated than that. (don't know if i'm explaining myself clear),but I attached a sample of the data for anyone willing to help.
I receive the data the same as table 1 and need to change it to looks like table 2.
from table 1 the laterality column become the header and corresponding values gets transpose from column orientation to row orientation.
Thank you in advance for any help or guidance on how to deal whit it.
Respectfully,
Alex
Bookmarks