VBA transpose specific columns to rows based on value in other column

**MB1983DK** · 04-15-2021, 04:39 AM

Hi,

I would like to transpose a specific column to rows based on the value in another column. So far I have managed to get the code to transpose the value in the column. However I would like it to transpose the same values for each individual variable in column A i.e. so that in this case would paste the same values in lines 1 to 3, 4 to 5, 6 to 7, 8 to 10 etc. See attached example

Please Login or Register  to view this content.

**nankw83** · 04-15-2021, 08:59 AM

Hi MB1983DK,

If this is solved & you don't need VBA code, you can mark the thread as [SOLVED] from the Thread Tools above your first post. However, if you still need VBA option, does the attached file show your data before the macro or this is what you're looking for after running the macro ?

VBA transpose specific columns to rows based on value in other column

LinkBack

Thread Tools

Rate This Thread

Display

VBA transpose specific columns to rows based on value in other column

Re: VBA transpose specific columns to rows based on value in other column

Thread Information

Users Browsing this Thread

Similar Threads

Transpose Specific Column Ranges to Rows, Autofill?

[SOLVED] Macro to transpose rows into columns and paste to specific columns in another sheet

Formula to transpose rows to column with specific criteria

Transpose column to rows based on values in two other columns

Transpose Columns into Rows based on Unique Identifier for n columns

Moving rows to columns based on information in a specific column

[SOLVED] Transpose Rows to Columns VBA Code and delete specific account numbers

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions