Transpose rows to column and insert new rows to fill in data

**Apple Ling** · 01-23-2019, 11:07 PM

Hello,
I have 4 or more fix columns need to retain and fill down the data once transpose done. However, the VBA script that I obtained from internet only allow me to fill down two columns. Can someone help to modify?

Please Login or Register  to view this content.

**jindon** · 01-23-2019, 11:26 PM

See if this is how you want.

Please Login or Register  to view this content.

**alansidman** · 01-23-2019, 11:40 PM

An alternative solution is to load your range/table into Power Query and unpivot the category columns. Here is the Mcode to do that. I just noticed that you are using XL 2003. Power Query is not available to you. My apologies. But if you are using 2010 or later it is. If that is the case, please update your profile to reflect the proper version of Excel that you are employing.

Please Login or Register  to view this content.

**Apple Ling** · 01-24-2019, 02:38 AM

If I have extra fix columns, how can I manage these extra columns? I am not familiar VBA.

**jindon** · 01-24-2019, 02:56 AM

You MUST select the header row as well.

Please Login or Register  to view this content.

**Apple Ling** · 01-24-2019, 03:58 AM

The script stop at this stage If myCols = 0 Then Exit Sub. No result coming out.

**jindon** · 01-24-2019, 04:02 AM

If you are running the code on the file which is different from the one you uploaded, it could happen.

You should have uploaded the file that you are using.

Transpose rows to column and insert new rows to fill in data

LinkBack

Thread Tools

Rate This Thread

Display

Transpose rows to column and insert new rows to fill in data

Re: Transpose rows to column and insert new rows to fill in data

Re: Transpose rows to column and insert new rows to fill in data

Re: Transpose rows to column and insert new rows to fill in data

Re: Transpose rows to column and insert new rows to fill in data

Re: Transpose rows to column and insert new rows to fill in data

Re: Transpose rows to column and insert new rows to fill in data

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Insert multiply rows and Transpose from Row to Column

[SOLVED] MACRO to insert rows and transpose values into new rows.

Insert rows based on a cell value and Fill down column A

Insert rows and then transpose data from a horizontal row into a column

[SOLVED] Need Help w/Macro that Insert Rows, Copy Row, and Transpose to Column

[SOLVED] Insert Rows and Transpose Data

Insert rows, transpose data from column in to rows, in steps

Bookmarks

Bookmarks

Posting Permissions