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.
Bookmarks