How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask R.R. Jha Your Own Question
R.R. Jha
R.R. Jha, Tutor
Category: Homework
Satisfied Customers: 5471
Experience:  B.Tech
20870358
Type Your Homework Question Here...
R.R. Jha is online now
A new question is answered every 9 seconds

I need to write a vba code in excel macro to realize the transpose

This answer was rated:

I need to write a vba code in excel macro to realize the transpose of a subset of columns into rows
Original Dataset
ColA ColB ColC ColD ColE ColF
A aa bb dd
B ccc eee ffff gggg
C acb efv edd eeeee erft

into
ColA ColB
A aa
A bb
A dd
B ccc
B eee
B ffff
B ggg
C acb
C efv
C edd
C eeeee
C erft
Hi,

I'd be glad to help. I'll work on this and send code soon.


Thanks
Customer: replied 4 years ago.
how was this going on
Working on it, would post it asap
Is that complete data set? Or should I assume you've to follow the pattern for all rows and columns in the worksheet? And should I put transposed data on a new worksheet?
Customer: replied 4 years ago.

this is not the complete data set. the complete data has 30 columns, but only Column b-f and aa-ac need to be transposed and the rest column need to be kept as what it was.


Can I sent you a sample excel file to make it clear ??


where can i upload the file


 

Yes, please send in the sample file. You may upload the file at wikisend.com or mediafire.com and post download link here.
Customer: replied 4 years ago.

http://wikisend.com/download/468168/Workbook6.xlsx


sheet 1 is the original data


sheet 2 is the result i want with the macro

Ok, for all rows in sheet 1? Until OOO?
Customer: replied 4 years ago.

o yeah......

Alright
Please download excel file below. Included is macro 'MyTranspose'

https://www.box.com/s/paz0zkzjts1u6vm6f2ki


Thanks
Customer: replied 4 years ago.

it deletes the rows have nothing in category 1 or category 2, but have values in other cells


for example


name category 1 date amount position category 2


aaa 3/1/2011 30 11 11 12 13


bbb 1 2 3 4/1/2011 40 12


 


results should be


name category 1 date amount position category 2


aaa 3/1/2011 30 11 11


12


13


bbb 1 4/1/2011 40 12


2


3

Customer: replied 4 years ago.


http://wikisend.com/download/573166/workbook6.xlsm


 


Please find the Correct Results Tab is the data I want, the original data is in Sheet 1. And the wrong result with the marco you write is in Trasposed Data Sheet.


 


it seems the code cannot retrive the rows for AAA, and III whose Category 1 is empty.

THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
R.R. Jha and other Homework Specialists are ready to help you