I have data in a column format which i want to convert to row format for easier calculations. My input is in SHEET1 and expected output in SHEET2. I am not sure if i need VBA for this or can it be done by normal excel functions. As and when i update or modify my data in sheet 1 the changes should reflect in sheet2. Please find attached.
Last edited by thebeastslayer; 09-29-2020 at 02:40 AM.
Try
Please Login or Register to view this content.
That was amazing. I couldnt replicate the code for my original data set . Can you please modify the code for me . Apologies. Here is the original dataset.
Change 3 to 12
Please Login or Register to view this content.
Will these code work for unlimited rows?
That's what you should find out for yourself.
If it doesn't work as you expect, upload the workbook in question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks