Transposing data to multiple columns

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

Yes you can do this but it would be far better for all concerned to upload an actual sample file as opposed to an image, else we are obliged to sit and type out data to replicate your setup... which given we do this in our spare time is likely to put most off answering your post.

See the attached -- sheet2 holds output.

Notes:
-- 2 helper columns added to Sheet1 such that expensive array formulae can be avoided.
-- Assumption made per sample that data is sorted by Client and then by Date

Alternative approach would be to use VBA ... pending volume of data I would not advise use of Arrays in this instance
(ie removing helpers will necessitate relatively expensive formulae IMO)