I need macro to copy a range of cells (B1:C4), then special paste transpose to (D1:G2), then go to B5 and repeat until the end.
Basically I have two columns that have sets of rows that I need to transfer to to columns. As an example:
1 A
2 A
3 A
4 A
1 B
2 B .. and so on
I need to transfer that to:
1 2 3 4
A A A A
1 2 3 4
B B B B and so on until the end of the data.
I would appreciate any help you can lend.
Last edited by lilynb; 08-05-2014 at 03:44 PM.
Try:
Please Login or Register to view this content.
Last edited by stnkynts; 08-05-2014 at 10:34 AM.
Thank you its almost right. I misstated one thing. In column A I have data that needs to stay related to the new columns. So what I really need is:
Q12 1 2 3 4
Q12 A A A A
Q12
Q12
X11
X11 ect.
So when I delete column B anc C it still has the correct column A data related to it.
Thanks
I do not understand your new needs. Please submit an example workbook with before and after examples so I get a clear picture of your requirements.
This is what it would look like. Columns A, Part- B,Area and C, Count are my original columns. I need to create Columns D,E,F,G.
I will later delete column B. So the ultimate end would be like:
X172 District 1 District 2 District 3 Total
X172 5 1 4 10
X498 District 1 District 2 District 3 Total
X498 2 2 5 9
Thanks for your help.
Couln't get it to show the columns right but you get the idea, there would 5 Columns.
Can anyone tell me how to put my worksheet on this forum.. in line.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks