Increase amount of columns in transpose

there seem to be problem that you want to go from vertical to horizontral, byt increase the output row, not column.

Start with such modification

Please Login or Register  to view this content.

and then adopt it to your needs.

This "and then adopt it to your need" was intentional - see emphasized phrase below:

Will you please attach a SMALL sample Excel workbook(s) (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

PS. This: "Plus it is not moving to the next line on the Sheet"Data" so it will overwrite the same row." was not mentioned in first post.
And as you PasteSpecial, the dropdowns will always be missing. Do you need them?

Provided all the options are completed...this will work...

Please Login or Register  to view this content.