Dear community,
I need assistance in creating a formula that will transpose data from rows to columns. I want to use some type of formula (vlookup, sumproduct, offset transpose, etc) or any excel function or macro, that would enable me to look up a value in an array and return the values in multiple columns based on the associated client Name and approval/expiration date. I have attached an example of the current and desired output.
If a company has multiple approvals they will be posted in separate rows. All information will remain the same for a company with the exception of the approval /expiration dates. Ex type of approval,status of approval are the same for each entry. The only info changed are the new approval/expiration dates. Some companies may have 3-4 entries so the columns will need to expand to the right.
I will copy the data after completion so it does not matter if the new data is on the same or a new output sheet
Any help would be greatly appreciated.
Thank you
sampyth
Bookmarks